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

--
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

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

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

=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

=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

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

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