PDA

View Full Version : What is wrong with this If statement?



Shaolin
01-30-2008, 09:19 AM
=IF(S2="NO" AND T2="","must write something",IF(S2="YES" AND T2 <>"", "Must be blank",""))

ProteanBeing
01-30-2008, 09:48 AM
=if(evaluation, True, false)

=if(and(s2="NO", T2=""), "must write something", "Must be blank")

you cannot do compound if statements in a cell

PhilJette
01-30-2008, 09:50 AM
=if(and(S2="no", T2=""),"Must Write Something",if(and(S2="yes", T2<>""),"Must be blank",""))

PhilJette
01-30-2008, 09:54 AM
=if(evaluation, True, false)

=if(and(s2="NO", T2=""), "must write something", "Must be blank")

you cannot do compound if statements in a cell

Sorry but unless I'm missunderstanding I don't believe that's true. You can have as many nested ifs as you like in a single cell

ProteanBeing
01-30-2008, 10:02 AM
I guess you can compound if's (sorry). The and statement should have worked though

Bob Phillips
01-30-2008, 10:11 AM
Sorry but unless I'm missunderstanding I don't believe that's true. You can have as many nested ifs as you like in a single cell

Sorry, but that is not true.

Prior to Excel 2007, you can only have 7 nested functions, including IF.

PhilJette
01-30-2008, 10:23 AM
ah touch?
Sorry about that, thanks for the clarification

RonMcK
01-30-2008, 10:23 AM
Sorry but unless I'm missunderstanding I don't believe that's true. You can have as many nested ifs as you like in a single cell
Phil, almost correct, I believe the limit is 7 nested if statements in a cell.

Ron

(hmm? I see my answer was good only prior to 2007) ;-)