IF Statement Help
 

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

IF Statement Help
 

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")))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Maggie" wrote:

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

IF Statement Help
 

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<""),"Ye s",IF(E3=50%,"Yes","No")))
but this one is shorter
=IF(AND(E3="",F3=""),"",IF(OR(AND(F3<=660,F3<""), E350%),"Yes","No"))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Maggie" wrote in message
...
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

IF Statement Help
 

Check your other post, too.

Maggie wrote:

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

--

Dave Peterson