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

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

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

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

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

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

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

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