IF Statement Help

M

Maggie

I have a IF statement that is not working please help.

=if(AF3<=660,"Yes",if(AE3>=50%,"Yes","No"). When I input 49% in AE3
it says Yes, when I need it to say No. It is counting AF3 as a 0,
when it is blank. I would also like to have the cell blank when both
AF3 and AE3 are blank.


Please help
 
L

Luke M

you didn't specifically say. but did you want it blank if AF3 is blank?

If so,
=IF(ISBLANK(AF3),"",IF(AF3<=660,"Yes",IF(AE3>=50%,"Yes","No")))
If you only want it blank when both cells are empty
=IF(AND(ISBLANK(AF3),ISBLANK(AE3)),"",
IF(AF3<=660,"Yes",IF(AE3>=50%,"Yes","No")))
 
S

Shane Devenshire

Hi,

You haven't spelled out all the possible results: What do you want to do
if only AF3 is blank or only AE3 is blank.

These might meet your needs:

=IF(AND(E3="",F3=""),"",IF(AND(F3<=660,F3<>""),"Yes",IF(E3>=50%,"Yes","No")))
but this one is shorter
=IF(AND(E3="",F3=""),"",IF(OR(AND(F3<=660,F3<>""),E3>50%),"Yes","No"))
 
D

Dave Peterson

Check your other post, too.
I have a IF statement that is not working please help.

=if(AF3<=660,"Yes",if(AE3>=50%,"Yes","No"). When I input 49% in AE3
it says Yes, when I need it to say No. It is counting AF3 as a 0,
when it is blank. I would also like to have the cell blank when both
AF3 and AE3 are blank.

Please help
Click to expand...
 
Top