Formula w/negative no.s & Percentage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anshin - 12 Apr 2006 22:48 GMT

Let's say I've created column A(# DAYS BETWEEN ASSIGNED & DUE DATE) and B (#
DAYS BETWEEN TODAY & 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!

Reply to this Message

pdberger - 13 Apr 2006 00:12 GMT

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)<1,(B2-A2)/(C2-A2),-(B2-A2)/(C2-A2)+1)
Here's another:
=IF((B2-A2)/(C2-A2)<1,(B2-A2)/(C2-A2),"Overdue!")

Hope that helps.

> Let's say I've created column A(# DAYS BETWEEN ASSIGNED & DUE DATE) and B (#
> DAYS BETWEEN TODAY & DUE DATE) Column C calculates number of days between
[quoted text clipped - 5 lines]
> 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!

Reply to this Message

Anshin - 14 Apr 2006 20:09 GMT

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

Anshing.

> Anshin --
>
[quoted text clipped - 20 lines]
> > 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!

Reply to this Message