And function

  • Thread starter Thread starter Allison
  • Start date Start date
A

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.
 
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
 
=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)
 
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"
 
Back
Top