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
|