Lookup/If Statement Inquiry 1

[Cordury]

I have a set of 6 numbers:
500
400
300
200
180
150

If a cell equals any of the above numbers I want the cell value to be multipled by .56 if else, multiply the cell value by .185

I am having issues with the embedded is statement. Should I add another column and try using a lookup (using a table or matrix):

A B
500 Default
400 Default
300 Default
200 Default
180 Default
150 Default


Thus anything not returning "Default" in the lookup column could be multi[lied by .185?

Ideas thoughts?

 

[bluedragon2]

=IF(ISERROR(VLOOKUP(C1,A1:A6,1,0)),C1*0.185,C1*0.56)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Cordury]

Thanks Blue. However, I did not post the proper. I have a column of numbers, and if the value is not

500
400
300
200
180
150

I just want to return the value in the cell. If it is one of the above values, I would like to muliply it by .56

Thanks,
Cord

 

[Cordury]

=IF(ISERROR(VLOOKUP(C1,A1:A6,1,0)),C1*0.56,C1)

Would that work?

 

[bluedragon2]

=IF(ISERROR(VLOOKUP(C1,A1:A6,1,0)),C1,C1*0.56)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Cordury]

Thanks, I was close