And function

[Allison]

I am creating an if/and formula. It is nested to 6 levels
and works, but I can only get True or False as the text
result. I would like the result to be Yes or No. Is
there a way to do this? Thanks.

 

[Don Guillett]

As always, post YOUR formula/code for comments.

 

[Allison]

Thanks Don. This is what I have done:

Cell e2 contains the date the employee is eligible for the
benefit. Cells e2, f2, g2, have completion dates for
certain forms that must be completed by the date eligible
in order to qualify for the benefit.

=IF(e2<=d2,AND(IF(f2<=d2,AND(IF(g2<=d2,true,false)))))

I would like the result of the formula to be Yes or No
rather than true or false. When I use Yes and No I get an
error message of #value.

Thanks so much for your help!!!Allison

 

[Don Guillett]

=IF(e2<=d2,AND(IF(f2<=d2,AND(IF(g2<=d2,true,false)))))
try this. You may have to add more ) 's
=IF(and(e2<=d2,f2<=d2,g2<=d2),true,false)

 

[Aladin Akyurek]

1)

=IF(COUNTBLANK(E2:G2),0,AND(E2<=D2,F2<=D2,G2<=D2)+0)

Custom format the formula cell as:

[=0]"No";[=1]"Yes"

2)

=(COUNTBLANK(E2:G2)=0)*(MAX(E2:G2)<=D2)

Custom format the formula cell as:

[=0]"No";[=1]"Yes"

 

[Harlan Grove]

try this. You may have to add more ) 's
=IF(and(e2<=d2,f2<=d2,g2<=d2),true,false)

...

Or just

=(MIN(E2:G2)<=D2)

which returns TRUE/FALSE.

 

[Don Guillett]

a goody.