• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Nested IF Statements with ISTEXT [SOLVED]

maradykstra

New Member
I'm trying to return a specific statement depending on what cells are entered. If someone puts text in A7 then that returns a text I want so that was:

=IF(ISTEXT(A7),E2,"")


Then if someone enters text in A7 and B7, then that returns a different text I want so that was:

=IF(AND(ISTEXT(A7),ISTEXT(B7)),E3,"")


Again, if someone enters A7,B7 and C7, then that returns a different text that I was so that was:

=IF(AND(ISTEXT(A7),ISTEXT(B7),ISTEXT(C7)),E4,"")


My question is that I want to combine all of these IF statements so if someone enters text in one cell then it returns that or if they entere text in two cells then it returns something else or if the enter text in all three cells it returns something else.

Does that make sense? I've been having trouble combining all three into one.


Thanks for your help!

Mara
 

Hui

Excel Ninja
Staff member
Pure Co-incidence,

I logged in 5 seconds after you posted

you could easily add

=if(COUNTA(A7:C7)=0,"0",CHOOSE(COUNTA(A7:C7),E2,E3,E4))

or change the "0" TO a message "No data"
 
Top