combining IF, AND, and OR Functions
 

=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

combining IF, AND, and OR Functions
 

Not sure what you are trying to accomplish, parts of your formula don't make
sense. Tell us what you want, but not in formulaic terms:
i.e.:
First check if G9<0, if yes, do something, if no, do something else, etc.
--
John C


"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

combining IF, AND, and OR Functions
 

Perhaps you should look at the help index for AND & OR to see the proper
syntax

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

combining IF, AND, and OR Functions
 

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

combining IF, AND, and OR Functions
 

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

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