Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |