| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Nested IF question
I need to create a formula which states like this
IF ( A1 ' ' AND B1 ' ' AND C1 ' ' Then 'hai', IF D1 ' ' AND E1 ' ' Then 'Hello') Can you guys help |
|
#2
|
|||
|
|||
|
-- Gary''s Student What if none of the cells are blank? "joe" wrote: I need to create a formula which states like this IF ( A1 ' ' AND B1 ' ' AND C1 ' ' Then 'hai', IF D1 ' ' AND E1 ' ' Then 'Hello') Can you guys help |
|
#3
|
|||
|
|||
|
I just gave an example, I will have values or Blanks
"Gary''s Student" wrote: -- Gary''s Student What if none of the cells are blank? "joe" wrote: I need to create a formula which states like this IF ( A1 ' ' AND B1 ' ' AND C1 ' ' Then 'hai', IF D1 ' ' AND E1 ' ' Then 'Hello') Can you guys help |
|
#4
|
|||
|
|||
|
O.K. then...
This formula will work: =IF(AND(A1=" ",B1=" ",C1=" "),"hai",IF(AND(D1=" ",E1=" "),"Hello"," ")) -- Gary''s Student "joe" wrote: I just gave an example, I will have values or Blanks "Gary''s Student" wrote: -- Gary''s Student What if none of the cells are blank? "joe" wrote: I need to create a formula which states like this IF ( A1 ' ' AND B1 ' ' AND C1 ' ' Then 'hai', IF D1 ' ' AND E1 ' ' Then 'Hello') Can you guys help |
|
#5
|
|||
|
|||
|
=if(and(a1="",b1="",c1=""),"hai",if(and(d1="",e1=" "),"hello","what goes here?"))
joe wrote: I need to create a formula which states like this IF ( A1 ' ' AND B1 ' ' AND C1 ' ' Then 'hai', IF D1 ' ' AND E1 ' ' Then 'Hello') Can you guys help -- Dave Peterson |
|
#6
|
|||
|
|||
|
=IF(AND(ISBLANK(A3), ISBLANK(B3), ISBLANK(C3)),"hai", IF(AND(ISBLANK(D3),
ISBLANK(E3)), "Hello","false")) "joe" wrote: I need to create a formula which states like this IF ( A1 ' ' AND B1 ' ' AND C1 ' ' Then 'hai', IF D1 ' ' AND E1 ' ' Then 'Hello') Can you guys help |
|
#7
|
|||
|
|||
|
I just posted a nested if statement, but started thinking and thought this
would work better for you. =IF(AND(ISBLANK(A1), ISBLANK(B1), ISBLANK(C1), D1<"", E1),"hai", IF(AND(ISBLANK(A1), ISBLANK(B1), ISBLANK(C1),ISBLANK(D1), ISBLANK(E1)), "Hello","?")) "Marie D" wrote: =IF(AND(ISBLANK(A3), ISBLANK(B3), ISBLANK(C3)),"hai", IF(AND(ISBLANK(D3), ISBLANK(E3)), "Hello","false")) "joe" wrote: I need to create a formula which states like this IF ( A1 ' ' AND B1 ' ' AND C1 ' ' Then 'hai', IF D1 ' ' AND E1 ' ' Then 'Hello') Can you guys help |
|
#8
|
|||
|
|||
|
Thanks guys
"Dave Peterson" wrote: =if(and(a1="",b1="",c1=""),"hai",if(and(d1="",e1=" "),"hello","what goes here?")) joe wrote: I need to create a formula which states like this IF ( A1 ' ' AND B1 ' ' AND C1 ' ' Then 'hai', IF D1 ' ' AND E1 ' ' Then 'Hello') Can you guys help -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested if question | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
| IF NESTED Question | Excel Worksheet Functions | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Linear Mode
