| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
