I would recommend that you look at Excel help to remind yourself of the
syntax for Excel functions such as IF, AND, and OR.
At present you are feeding text strings into the AND and OR functions, which
are looking for Booleans (TRUE or FALSE) as inputs.
I wonder whether what you intended may have been
=IF(AND(G90,F9=E9),"HOLD",IF(OR(F9<E9,F9<E9*1.03 5),"SELL","whatever your
alternative outcome is")) ?

If you are indeed intending to use OR(F9<E9,F9<E9*1.035) as part of the
test, then I assume that this is because E9 might not necessarily be
positive, because if E9 is positive the F9<E9 test is redundant as it would
always be satified if F9<E9*1.035
--
David Biddulph

"Hillary: needing some help"
m wrote in message
...
=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