semi-complicated nested IF statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tjb - 31 Aug 2005 21:06 GMT

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!

Reply to this Message

bj - 31 Aug 2005 21:19 GMT

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.

> OK here's the layout as best I can put it:
>
[quoted text clipped - 9 lines]
>
> Thanks everyone!

Reply to this Message

tjb - 31 Aug 2005 21:25 GMT

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?

> 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?
[quoted text clipped - 18 lines]
> >
> > Thanks everyone!

Reply to this Message

tjb - 31 Aug 2005 21:31 GMT

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!

> 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?
[quoted text clipped - 18 lines]
> >
> > Thanks everyone!

Reply to this Message