software

Let's say I've created column A(# DAYS BETWEEN ASSIGNED amp; DUE DATE) and B (#
DAYS BETWEEN TODAY amp; DUE DATE) Column C calculates number of days between
today's date and Due Date. Column D uses info in Column C to calculate what
percentage of completion the deliverable should be at. When a deliverable
is on track, Column C will have a positve number using this formula
(=SUM(1-(K2/J2)) When Column C is a negative number representing something
overdue, the formula above does not work. I need a formula in essence to
show a negative percentage (e.g. - 25%) when the deliverable is overdue using
info from Columns, A, B, and C above as stated. Can anybody help please!

Anshin --

Here's an approach:
A B C D
Assigned Today Due Target
1-Mar-06= today() 25-Apr-06 Formula
1-Mar-06= today() 1-Apr-06

Here's one formula:
=IF((B2-A2)/(C2-A2)lt;1,(B2-A2)/(C2-A2),-(B2-A2)/(C2-A2) 1)
Here's another:
=IF((B2-A2)/(C2-A2)lt;1,(B2-A2)/(C2-A2),quot;Overdue!quot;)

Hope that helps.quot;Anshinquot; wrote:

gt; Let's say I've created column A(# DAYS BETWEEN ASSIGNED amp; DUE DATE) and B (#
gt; DAYS BETWEEN TODAY amp; DUE DATE) Column C calculates number of days between
gt; today's date and Due Date. Column D uses info in Column C to calculate what
gt; percentage of completion the deliverable should be at. When a deliverable
gt; is on track, Column C will have a positve number using this formula
gt; (=SUM(1-(K2/J2)) When Column C is a negative number representing something
gt; overdue, the formula above does not work. I need a formula in essence to
gt; show a negative percentage (e.g. - 25%) when the deliverable is overdue using
gt; info from Columns, A, B, and C above as stated. Can anybody help please!

Thank you, thank you!! You saved my life!! This worked perfectly.

Anshing.

quot;pdbergerquot; wrote:

gt; Anshin --
gt;
gt; Here's an approach:
gt; A B C D
gt; Assigned Today Due Target
gt; 1-Mar-06= today() 25-Apr-06 Formula
gt; 1-Mar-06= today() 1-Apr-06
gt;
gt; Here's one formula:
gt; =IF((B2-A2)/(C2-A2)lt;1,(B2-A2)/(C2-A2),-(B2-A2)/(C2-A2) 1)
gt; Here's another:
gt; =IF((B2-A2)/(C2-A2)lt;1,(B2-A2)/(C2-A2),quot;Overdue!quot;)
gt;
gt; Hope that helps.
gt;
gt;
gt; quot;Anshinquot; wrote:
gt;
gt; gt; Let's say I've created column A(# DAYS BETWEEN ASSIGNED amp; DUE DATE) and B (#
gt; gt; DAYS BETWEEN TODAY amp; DUE DATE) Column C calculates number of days between
gt; gt; today's date and Due Date. Column D uses info in Column C to calculate what
gt; gt; percentage of completion the deliverable should be at. When a deliverable
gt; gt; is on track, Column C will have a positve number using this formula
gt; gt; (=SUM(1-(K2/J2)) When Column C is a negative number representing something
gt; gt; overdue, the formula above does not work. I need a formula in essence to
gt; gt; show a negative percentage (e.g. - 25%) when the deliverable is overdue using
gt; gt; info from Columns, A, B, and C above as stated. Can anybody help please!