semi-complicated nested IF statement
 

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(A31040,if(A4date(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(A31040,if(A4date(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(A31040,if(A4date(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!