Please help!

[Scoooter]

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(AK3>15,"Very Overdue"))))

Thank you
Scoooter

 

[Guest]

=IF(AR2="closed","Not Required",IF(AK3<=5,"",IF(AK3<=10,"Almost
Due",IF(AK3<=15,"Overdue",IF(AK3>15,"Very Overdue")))))

 

[Guest]

Do you mean this?

=IF(AR2="Closed","Not required",IF(AK3<=5,"",IF(AK3<=10,"Almost
Due",IF(AK3<=15,"Overdue",IF(AK3>15,"Very Overdue")))))


AR2 is not referred to in your original formula

 

[CarlosAntenna]

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(AK3>15,"Very Overdue")))))

 

[Bearacade]

=IF(AR2="closed", "Not Required", ""

 

[CarlosAntenna]

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"))))

 

[Scoooter]

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.

 

[Scoooter]

Thanks everyone, got it working.

Scoooter

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.