=IF(S2="NO" AND T2="","must write something",IF(S2="YES" AND T2 <>"", "Must be blank",""))
=IF(S2="NO" AND T2="","must write something",IF(S2="YES" AND T2 <>"", "Must be blank",""))
=if(evaluation, True, false)
=if(and(s2="NO", T2=""), "must write something", "Must be blank")
you cannot do compound if statements in a cell
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being
[VBA]
=if(and(S2="no", T2=""),"Must Write Something",if(and(S2="yes", T2<>""),"Must be blank",""))
[/VBA]
Phil J.
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 cellOriginally Posted by ProteanBeing
Phil J.
I guess you can compound if's (sorry). The and statement should have worked though
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being
Sorry, but that is not true.Originally Posted by PhilJette
Prior to Excel 2007, you can only have 7 nested functions, including IF.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
ah touch?
Sorry about that, thanks for the clarification
Phil J.
Phil, almost correct, I believe the limit is 7 nested if statements in a cell.Originally Posted by PhilJette
Ron
(hmm? I see my answer was good only prior to 2007) ;-)