simple if then function

A

amy

I know this should be simple but I am having problems
if f9=xa then f20=133
if f9=tc then f20=168
if f9=xb then f20= 145

I had done these years ago and just can't get this simple formula to work.
Any help you can give me would be greatly appreciated.

Thank you
 
D

dominicb

Good afternoon Amy

This formula when placed in cell F20 will do what you want. If F9
doesn't equal xa, tx or xb then the cell will show as empty.

=IF(F9="xa",133,IF(F9="tc",168,IF(F9="xb",155,"")))

HTH

DominicB
 
C

CLR

IN cell F20 put this formula....

=IF(F9="xa",133,IF(F9="tc",168,IF(F9="XB",145,"")))

Vaya con Dios,
Chuck, CABGx3
 
Top