View Single Post
  #1   Report Post  
Lori Lynn
 
Posts: n/a
Default Formula for calculating Variance


I need help with formulas to calculate the percentage of variance
between planned miles and actual miles driven by drivers at several
different locations. I am given the miles per location daily. I need
to calculate weekly percentage per location. Then YTD percentage per
local, then total for all locals, then YTD for all locals. Can someone
help me?


--
Lori Lynn
------------------------------------------------------------------------
Lori Lynn's Profile: http://www.excelforum.com/member.php...o&userid=25565
View this thread: http://www.excelforum.com/showthread...hreadid=389974