I need some help with this formula

=IF(A2=0,"",IF(J2=TODAY(),"Due
Today",IF(J2<TODAY(),"Overdue",(IF(K2<=J2,"Ontime" ,IF(K2J2,"Late"))))))

the value does not change to "ontime" or "late" when I put in the
appropriate date. What did I do wrong.

Works for me just fine -- do you have your calculation option set to
automatic???

"Roy" wrote:

I need some help with this formula

=IF(A2=0,"",IF(J2=TODAY(),"Due
Today",IF(J2<TODAY(),"Overdue",(IF(K2<=J2,"Ontime" ,IF(K2J2,"Late"))))))

the value does not change to "ontime" or "late" when I put in the
appropriate date. What did I do wrong.

yes calculation option is set to automatic.

"Eric" wrote:

Works for me just fine -- do you have your calculation option set to
automatic???

"Roy" wrote:

I need some help with this formula

=IF(A2=0,"",IF(J2=TODAY(),"Due
Today",IF(J2<TODAY(),"Overdue",(IF(K2<=J2,"Ontime" ,IF(K2J2,"Late"))))))

the value does not change to "ontime" or "late" when I put in the
appropriate date. What did I do wrong.

I have no other suggestions except this...

On an older version of Excel, I would occasionally have problems.... And I
would end up pasting all of the contents of my sheet into a new one to get
formulas to work. I don't know why, but it fixed it.

TO double check that your calculations are happening automatically, try
changing the date and then hit F9 -- if it changes to its correct value....
then some automatic setting is wrong.

Eric

"Roy" wrote:

yes calculation option is set to automatic.

"Eric" wrote:

Works for me just fine -- do you have your calculation option set to
automatic???

"Roy" wrote:

I need some help with this formula

=IF(A2=0,"",IF(J2=TODAY(),"Due
Today",IF(J2<TODAY(),"Overdue",(IF(K2<=J2,"Ontime" ,IF(K2J2,"Late"))))))

the value does not change to "ontime" or "late" when I put in the
appropriate date. What did I do wrong.

Besides A2 being not equal to 0, do you realize that if J2 is not greater
(later) then today, you'll never see "Ontime" or "Late" returned by the
formula, no matter what's in K2?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Roy" wrote in message
...
I need some help with this formula

=IF(A2=0,"",IF(J2=TODAY(),"Due
Today",IF(J2<TODAY(),"Overdue",(IF(K2<=J2,"Ontime" ,IF(K2J2,"Late"))))))

the value does not change to "ontime" or "late" when I put in the
appropriate date. What did I do wrong.

Roy

If J2=TODAY() you get "Due Today"

If J2<TODAY() you get "Overdue"

K2=J2 or K2J2 can never be satisfied if either of the first two conditions
are true.

You are trying to satisfy too many conditions as far as I can see.

Conditons 1 or 2 come before conditions 3 or 4

You mention you put in the "appropriate date".

Where are you putting it?


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 11:46:00 -0800, Roy wrote:

yes calculation option is set to automatic.

"Eric" wrote:

Works for me just fine -- do you have your calculation option set to
automatic???

"Roy" wrote:

I need some help with this formula

=IF(A2=0,"",IF(J2=TODAY(),"Due
Today",IF(J2<TODAY(),"Overdue",(IF(K2<=J2,"Ontime" ,IF(K2J2,"Late"))))))

the value does not change to "ontime" or "late" when I put in the
appropriate date. What did I do wrong.