IN cell F20 put this formula....

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

Vaya con Dios,
Chuck, CABGx3


"amy" wrote in message
...
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