If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiple AND conditions with IF's
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(G230,H230),"oops","")), (IF(AND(G230,H230),"MAYBE","")), (IF(AND(G230,H230),"MAYBE","")), (IF(AND(G230,H230),"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 |
#2
|
|||
|
|||
multiple AND conditions with IF's
David
You just had your formula a little bit out!! Try this: =(IF(AND(G230,H230),"oops",IF(AND(G230,H230)," MAYBE",IF(AND(G230,H230) ,"MAYBE",(IF(AND(G230,H230),"YAY","")))))) Andy. "David" wrote in message ... 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(G230,H230),"oops","")), (IF(AND(G230,H230),"MAYBE","")), (IF(AND(G230,H230),"MAYBE","")), (IF(AND(G230,H230),"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 |
#3
|
|||
|
|||
multiple AND conditions with IF's
=IF(AND(G230,H230),"oops",IF(AND(G230,H230),"M AYBE",IF
(AND(G230,H230),"MAYBE",IF(AND(G230,H230),"YAY ","")))) HTH Jason Atlanta, GA -----Original Message----- 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(G230,H230),"oops","")), (IF(AND(G230,H230),"MAYBE","")), (IF(AND(G230,H230),"MAYBE","")), (IF(AND(G230,H230),"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 . |
Thread Tools | |
Display Modes | |
|
|