| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.programming
|
|||
|
|||
|
IF Statement Help
Try this...
=IF(AND(AF3<=660,AF3<""),"Yes",IF(AE3=50%,"Yes", "No")) -- Rick (MVP - Excel) "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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF Statement Help
You can not use AF3=50%, you must use AF3=.5
=IF(AND(ISBLANK(AE3),ISBLANK(AF3)),"",IF(AF3<=660, "Yes",IF(AE3=0.5,"Yes","No"))) HTH, "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF Statement Help
Yes, you can use: af3=50%
It may make it easier for the OP to read the formula. DataHog wrote: You can not use AF3=50%, you must use AF3=.5 =IF(AND(ISBLANK(AE3),ISBLANK(AF3)),"",IF(AF3<=660, "Yes",IF(AE3=0.5,"Yes","No"))) HTH, "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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF Statement Help
On Jan 7, 1:39*pm, Dave Peterson wrote:
Yes, you can use: af3=50% It may make it easier for the OP to read the formula. DataHog wrote: You can not use AF3=50%, you must use AF3=.5 =IF(AND(ISBLANK(AE3),ISBLANK(AF3)),"",IF(AF3<=660, "Yes",IF(AE3=0..5,"Yes","*No"))) HTH, "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- Hide quoted text - - Show quoted text - What if I want if AE3 and AF3 are blank then leave blank. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF Statement Help
Okay AE350% does work just fine, my bad.
This formula works if ae3 and af3 are both blank or ae3 has a value and af3 is blank or ae3 has a value and af3 has a value =IF(AND(ISBLANK(AE3),ISBLANK(AF3)),"",IF(AND(AF3<= 660, AF3<""),"Yes",IF(AE3=50%,"Yes","No"))) HTH, Jim K "Maggie" wrote: On Jan 7, 1:39 pm, Dave Peterson wrote: Yes, you can use: af3=50% It may make it easier for the OP to read the formula. DataHog wrote: You can not use AF3=50%, you must use AF3=.5 =IF(AND(ISBLANK(AE3),ISBLANK(AF3)),"",IF(AF3<=660, "Yes",IF(AE3=0..5,"Yes","Â*No"))) HTH, "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- Hide quoted text - - Show quoted text - What if I want if AE3 and AF3 are blank then leave blank. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF Statement Help
You already have that answer.
Maggie wrote: On Jan 7, 1:39 pm, Dave Peterson wrote: Yes, you can use: af3=50% It may make it easier for the OP to read the formula. DataHog wrote: You can not use AF3=50%, you must use AF3=.5 =IF(AND(ISBLANK(AE3),ISBLANK(AF3)),"",IF(AF3<=660, "Yes",IF(AE3=0.5,"Yes","*No"))) HTH, "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- Hide quoted text - - Show quoted text - What if I want if AE3 and AF3 are blank then leave blank. -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF Statement Help
=if(and(af3="",ae3=""),"",if(af3<=660,....
Maybe you really want =or() =if(or(af3="",ae3=""),"",if(af3<=660,.... 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 | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
