Help Convert

R

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
 
M

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
 
Top