View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Scott_goddard Scott_goddard is offline
external usenet poster
 
Posts: 32
Default 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