IF Statement Help

  • Thread starter Thread starter Maggie
  • Start date Start date
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
 
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")))
 
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"))
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statement Help 7
Charts from 2003 not working in 2007 2
Conditional format for complete column 1
Change color of cell when different cell has data entered 1
data from internet not showing up 6
INDIRECT Follow On 4
fill randomly cells that verify contion 5
VBA ln function 2

Back
Top