simple if then function
 

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

=hlookup(F9,{"xa","tc","xb";133,168,145},2,0)

"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

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=384943

tHANK YOU FOR YOUR EHLP IT WORKED GREAT. nEVER USED HLOOKUP BEFORE

"N Harkawat" wrote:

=hlookup(F9,{"xa","tc","xb";133,168,145},2,0)

"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

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