Help Convert

[rpastor]

Actually. what I need is something that states:
=IF(F10="BUY","IN"(IF(F10="SELL", "OUT", "Interest"))

Basically what I need it to say is if F10 is Buy" then it should sa
"IN". If F10 says Sell then it should say "OUT". If neither the
"interest

 

[Michael]

Hi Firstly, stick to the same thread. That way everybody
that reads your post knows whether it has been resolved or
not.
AND or OR does not apply in this case.
Try:
=IF(F10="BUY","IN",IF(F10="SELL", "OUT", "Interest"))

Regards
Michael