Help Convert

[rpastor]

Can someone help me rewrite this function using "IF" and "AND
statements?

=IF(I12>I11,"SELL",IF(I12>I13,"SELL",IF(I12<I11,"BUY","HOLD")))

I cannot get it to work???

Thanks
Rober

 

[Myrna Larson]

I think you want OR, not AND.

You have two conditions which indicate SELL, and you want to SELL if either
one OR the other is true.

=IF(OR(I12>I11,I12>I13),"SELL",IF(I12<I11,"BUY","HOLD"))

 

[Michael]

Hi
Try
=IF(AND(I12>I11,I12>I13),"SELL",IF(I12<I11,"BUY","HOLD"))
Regards
Michael