error.: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

[Bearacade]

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

[Paul Mathews]

=IF(AR2="closed","Not Required",IF(AK3<=5,"",IF(AK3<=10,"Almost
Due",IF(AK3<=15,"Overdue",IF(AK3>15,"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(AK3>15,"Very Overdue"))))
>
> Thank you
> Scoooter
>
>

[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


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

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

--
Carlos

"Scoooter" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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

--
Carlos

"CarlosAntenna" <[email protected]> wrote in message
news:[email protected]...
> 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")))))
>
> --
> Carlos
>
> "Scoooter" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>

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

Toppers wrote:

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

[Scoooter]

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