| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help!
Thanks everyone, got it working.
Scoooter Scoooter wrote: Thanks for that. I obviously have not thought about this to the degree that I should have. It now works but throws up a 'False' if AR2=Open. I need it to run through the argument as normal if AR2=Open but If AR2=Closed then I need it to show "Not Required". Thanks again. Toppers wrote: Do you mean this? =IF(AR2="Closed","Not required",IF(AK3<=5,"",IF(AK3<=10,"Almost Due",IF(AK3<=15,"Overdue",IF(AK315,"Very Overdue"))))) AR2 is not referred to in your original formula "Scoooter" wrote: Dear All I am trying to have the following argument state that IF AR2="closed",Then return "Not Required" but I keep getting an error. Would anyone be able to help me with this? =IF(AK3<=5,"",IF(AK3<=10,"Almost Due",IF(AK3<=15,"Overdue",IF(AK315,"Very Overdue")))) Thank you Scoooter |
Threaded Mode
