simple if then function

[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

[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

[N Harkawat]

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

"amy" <[email protected]> wrote in message
news:[email protected]...
>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
>

[amy]

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" <[email protected]> wrote in message
> news:[email protected]...
> >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
> >
>
>
>

[CLR]

IN cell F20 put this formula....

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

Vaya con Dios,
Chuck, CABGx3


"amy" <[email protected]> wrote in message
news:[email protected]...
> 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
>