Please help!

S

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
 
P

Paul Mathews

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

Toppers

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
 
C

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

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

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.
 
S

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.
Click to expand...
 
Top