semi-complicated nested IF statement

with what you have said you cannot do it without a macro or helper cell
do you really want to change A3 based on the value of A3?

is so use a helper cell and enter

=if(A3>1040,if(A4>date(2003,12,31),"DC04","RTONLY"),if(A3<1560,"AGRIZ","ADMINS"))

copy the helper cell and paste values on A3.

"tjb" wrote:

> OK here's the layout as best I can put it:
>
> If A3 has a number less than 1040, then I want it to look at A4 to see if a
> date is greater than or less than 12/31/03.
>
> If A4 has a date later than 12/31/03, I want A3 to read "DC04", if A4 has a
> date earlier than 1/1/04, I want A3 to read "RTONLY".
>
> Now back to A3, if A3 has a number greater than or equal to 1040 but less
> than 1560, I want A3 to read "AGRIZ". If A3 has a number greater than or
> equal to 1560, I want A3 to read "ADMINS".
>
> Thanks everyone!

No you're right, I was thinking to have the formula in A3 but it should look
at A5 for the data. how does that change the formula you gave?

"bj" wrote:

> with what you have said you cannot do it without a macro or helper cell
> do you really want to change A3 based on the value of A3?
>
> is so use a helper cell and enter
>
> =if(A3>1040,if(A4>date(2003,12,31),"DC04","RTONLY"),if(A3<1560,"AGRIZ","ADMINS"))
>
> copy the helper cell and paste values on A3.
>
> "tjb" wrote:
>
> > OK here's the layout as best I can put it:
> >
> > If A3 has a number less than 1040, then I want it to look at A4 to see if a
> > date is greater than or less than 12/31/03.
> >
> > If A4 has a date later than 12/31/03, I want A3 to read "DC04", if A4 has a
> > date earlier than 1/1/04, I want A3 to read "RTONLY".
> >
> > Now back to A3, if A3 has a number greater than or equal to 1040 but less
> > than 1560, I want A3 to read "AGRIZ". If A3 has a number greater than or
> > equal to 1560, I want A3 to read "ADMINS".
> >
> > Thanks everyone!

I was using a different date format than why you suggested and that's what
was causing me issues. Using your format works now so thanks a ton!

"bj" wrote:

> with what you have said you cannot do it without a macro or helper cell
> do you really want to change A3 based on the value of A3?
>
> is so use a helper cell and enter
>
> =if(A3>1040,if(A4>date(2003,12,31),"DC04","RTONLY"),if(A3<1560,"AGRIZ","ADMINS"))
>
> copy the helper cell and paste values on A3.
>
> "tjb" wrote:
>
> > OK here's the layout as best I can put it:
> >
> > If A3 has a number less than 1040, then I want it to look at A4 to see if a
> > date is greater than or less than 12/31/03.
> >
> > If A4 has a date later than 12/31/03, I want A3 to read "DC04", if A4 has a
> > date earlier than 1/1/04, I want A3 to read "RTONLY".
> >
> > Now back to A3, if A3 has a number greater than or equal to 1040 but less
> > than 1560, I want A3 to read "AGRIZ". If A3 has a number greater than or
> > equal to 1560, I want A3 to read "ADMINS".
> >
> > Thanks everyone!

OK here's the layout as best I can put it:

If A3 has a number less than 1040, then I want it to look at A4 to see if a
date is greater than or less than 12/31/03.

If A4 has a date later than 12/31/03, I want A3 to read "DC04", if A4 has a
date earlier than 1/1/04, I want A3 to read "RTONLY".

Now back to A3, if A3 has a number greater than or equal to 1040 but less
than 1560, I want A3 to read "AGRIZ". If A3 has a number greater than or
equal to 1560, I want A3 to read "ADMINS".

Thanks everyone!

with what you have said you cannot do it without a macro or helper cell
do you really want to change A3 based on the value of A3?

is so use a helper cell and enter

=if(A3>1040,if(A4>date(2003,12,31),"DC04","RTONLY"),if(A3<1560,"AGRIZ","ADMINS"))

copy the helper cell and paste values on A3.

"tjb" wrote:

> OK here's the layout as best I can put it:
>
> If A3 has a number less than 1040, then I want it to look at A4 to see if a
> date is greater than or less than 12/31/03.
>
> If A4 has a date later than 12/31/03, I want A3 to read "DC04", if A4 has a
> date earlier than 1/1/04, I want A3 to read "RTONLY".
>
> Now back to A3, if A3 has a number greater than or equal to 1040 but less
> than 1560, I want A3 to read "AGRIZ". If A3 has a number greater than or
> equal to 1560, I want A3 to read "ADMINS".
>
> Thanks everyone!

No you're right, I was thinking to have the formula in A3 but it should look
at A5 for the data. how does that change the formula you gave?

"bj" wrote:

> with what you have said you cannot do it without a macro or helper cell
> do you really want to change A3 based on the value of A3?
>
> is so use a helper cell and enter
>
> =if(A3>1040,if(A4>date(2003,12,31),"DC04","RTONLY"),if(A3<1560,"AGRIZ","ADMINS"))
>
> copy the helper cell and paste values on A3.
>
> "tjb" wrote:
>
> > OK here's the layout as best I can put it:
> >
> > If A3 has a number less than 1040, then I want it to look at A4 to see if a
> > date is greater than or less than 12/31/03.
> >
> > If A4 has a date later than 12/31/03, I want A3 to read "DC04", if A4 has a
> > date earlier than 1/1/04, I want A3 to read "RTONLY".
> >
> > Now back to A3, if A3 has a number greater than or equal to 1040 but less
> > than 1560, I want A3 to read "AGRIZ". If A3 has a number greater than or
> > equal to 1560, I want A3 to read "ADMINS".
> >
> > Thanks everyone!

I was using a different date format than why you suggested and that's what
was causing me issues. Using your format works now so thanks a ton!

"bj" wrote:

> with what you have said you cannot do it without a macro or helper cell
> do you really want to change A3 based on the value of A3?
>
> is so use a helper cell and enter
>
> =if(A3>1040,if(A4>date(2003,12,31),"DC04","RTONLY"),if(A3<1560,"AGRIZ","ADMINS"))
>
> copy the helper cell and paste values on A3.
>
> "tjb" wrote:
>
> > OK here's the layout as best I can put it:
> >
> > If A3 has a number less than 1040, then I want it to look at A4 to see if a
> > date is greater than or less than 12/31/03.
> >
> > If A4 has a date later than 12/31/03, I want A3 to read "DC04", if A4 has a
> > date earlier than 1/1/04, I want A3 to read "RTONLY".
> >
> > Now back to A3, if A3 has a number greater than or equal to 1040 but less
> > than 1560, I want A3 to read "AGRIZ". If A3 has a number greater than or
> > equal to 1560, I want A3 to read "ADMINS".
> >
> > Thanks everyone!