Posible IF formula

[Hanah]

A2 can have 3 kind of values. Eg. 1000, 2000, or 3000. If A2 is 1000, B2 is
140, if A2 is 2000, B2 is 14, if A2 is 3000, B2 is 177. Please help, how can
I write a formula for this.

 

[M Kan]

I think this is the formula in B2

=IF(A2=1000,140,IF(A2=2000,14,117))

 

[Hanah]

Thanks! This works! Great help!

"M Kan" a scris:

I think this is the formula in B2

=IF(A2=1000,140,IF(A2=2000,14,117))