combining IF, AND, and OR Functions
thank you!!
"Mike H" wrote:
Hi,
Try this
=IF(AND(G90,F9E9),"Hold",IF(OR(F9<E9,F9<E9*1.035 ),"Sell",""))
Mike
"Hillary: needing some help" wrote:
=IF(G90,
AND(F9=E9,"HOLD",
IF(F9<E9,
OR(F9<E9*1.035,"SELL"))))
not sure how to make this work
=IF(G90,AND(F9=E9,"HOLD",IF(F9<E9,OR(F9<E9*1.035 ,"SELL"))))
as one line it doesn't work how can I order it to where it will work
thanks
|