View Full Version : [SLEEPER:] 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) ;-)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.