Help with these forumla's
 

Task name Start Date Complete Remaining Start date % complete
Locations 27/11/2006 8.8 2.2 8/12/2006 80

In complete cell this formula is used =IF((I8-E8)*J8/100=0,0,(I8-E8)*J8/100)
In Remaining cell this formula is used =IF((I8-E8)-F8=0,"",(I8-E8)-F8)

My question is, what do these formula show? Complete / Remaining what?
Days? Percentage? If its days greats thats what I need and only working
days.

Please help ASAP

Help with these forumla's
 

It we knew what was in E8,I8 and J8 we might be able to help
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Scott_goddard" wrote in message
...
Task name Start Date Complete Remaining Start date % complete
Locations 27/11/2006 8.8 2.2 8/12/2006 80

In complete cell this formula is used
=IF((I8-E8)*J8/100=0,0,(I8-E8)*J8/100)
In Remaining cell this formula is used =IF((I8-E8)-F8=0,"",(I8-E8)-F8)

My question is, what do these formula show? Complete / Remaining what?
Days? Percentage? If its days greats that's what I need and only working
days.

Please help ASAP

Help with these forumla's
 

E8 - Start date
I8 - End date
J8 - Percentage completed

"Bernard Liengme" wrote:

It we knew what was in E8,I8 and J8 we might be able to help
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Scott_goddard" wrote in message
...
Task name Start Date Complete Remaining Start date % complete
Locations 27/11/2006 8.8 2.2 8/12/2006 80

In complete cell this formula is used
=IF((I8-E8)*J8/100=0,0,(I8-E8)*J8/100)
In Remaining cell this formula is used =IF((I8-E8)-F8=0,"",(I8-E8)-F8)

My question is, what do these formula show? Complete / Remaining what?
Days? Percentage? If its days greats that's what I need and only working
days.

Please help ASAP

Help with these forumla's
 

This =IF((I8-E8)*J8/100=0,0,(I8-E8)*J8/100) returns 0 when the two dates are
the same. In fact one could just use (I8-E8)*J8/100). When the dates are not
the same the formula multiplies the "number of days of the project" by
"percentage complete" and then divides by 100. Not very clear what the
purpose of this is. It does not seem to tell you anything useful.
In the send formula one subtracts 'percent complete' from 'number of days'.
Why would anyone do that?
Sorry I could not help
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Scott_goddard" wrote in message
...
E8 - Start date
I8 - End date
J8 - Percentage completed

"Bernard Liengme" wrote:

It we knew what was in E8,I8 and J8 we might be able to help
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Scott_goddard" wrote in message
...
Task name Start Date Complete Remaining Start date % complete
Locations 27/11/2006 8.8 2.2 8/12/2006 80

In complete cell this formula is used
=IF((I8-E8)*J8/100=0,0,(I8-E8)*J8/100)
In Remaining cell this formula is used =IF((I8-E8)-F8=0,"",(I8-E8)-F8)

My question is, what do these formula show? Complete / Remaining what?
Days? Percentage? If its days greats that's what I need and only
working
days.

Please help ASAP