View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CMA
 
Posts: n/a
Default 1-2-3 @ function to Excel Assistance


Looks like we are close. I did the formula you provided and this was my
result:

-10582.5%
It looks like it's 82.5% elasped since the start date but how do I get
rid of the number preceeding the 82.5%, and actually the boss would
probably rather not see the .5% and have it show 82% or round up/down
to the whole number.

Thanks a million for the assistance.


--
CMA
------------------------------------------------------------------------
CMA's Profile: http://www.excelforum.com/member.php...o&userid=32522
View this thread: http://www.excelforum.com/showthread...hreadid=523055