Help Convert

R

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
 
M

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"))
 
Top