multiple AND conditions with IF's

D

David

I have to create a column that shows traffic movement data.

I'm not really used to Excel and this is the formula I
have come up with thus far:

=(IF(AND(G23>0,H23>0),"oops","")),
(IF(AND(G23>0,H23<0),"MAYBE","")),
(IF(AND(G23<0,H23>0),"MAYBE","")),
(IF(AND(G23<0,H23<0),"YAY",""))


Each part on it's own works but when I put them together
it gives an output of '#VALUE'

I've tried some different ways of doing this but the
output is always either '#VALUE' or '#REF'

Any assistance would be much appreciated

Thanku
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max with Multiple Ifs 3
Multiple IF conditions 3
Averaging with IFs 2
Can I have two conditions in a SUMIF? 5
Cell text based on 4 condition test 3
Help with a conditional formula using ranges 5
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Multiple Conditions within an IF Function 2

Top