Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help!
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help!
=IF(AR2="closed","Not Required",IF(AK3<=5,"",IF(AK3<=10,"Almost
Due",IF(AK3<=15,"Overdue",IF(AK315,"Very Overdue"))))) "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help!
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help!
You need to wrap another IF around what you already have.
=if(AR2="closed","Not Required",IF(AK3<=5,"",IF(AK3<=10,"Almost Due",IF(AK3<=15,"Overdue",IF(AK315,"Very Overdue"))))) -- Carlos "Scoooter" wrote in message oups.com... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help!
=IF(AR2="closed", "Not Required", "") -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=551505 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help!
Also your last IF is incomplete, the third argument is missing. Try this
one without the last IF, using "Very Overdue" as the false argument in the IF before. =if(AR2="closed","Not Required",IF(AK3<=5,"",IF(AK3<=10,"Almost Due",IF(AK3<=15,"Overdue","Very Overdue")))) -- Carlos "CarlosAntenna" wrote in message ... You need to wrap another IF around what you already have. =if(AR2="closed","Not Required",IF(AK3<=5,"",IF(AK3<=10,"Almost Due",IF(AK3<=15,"Overdue",IF(AK315,"Very Overdue"))))) -- Carlos "Scoooter" wrote in message oups.com... 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help!
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 |
#8
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|