View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eddy Eddy is offline
external usenet poster
 
Posts: 13
Default possible to calculate % attainment using one formula?

I need to measure one set of data over the other. For example, Set A is
forecast and Set B is actuals.
Set A 591 107 (160) (559) (159)
Set B 362 (24) 50 (121) (295)

First pair of data is simple. 362/591= 61%. This means acutals is 61% to
fcst.

Is there a formula to cater to all scenarios above?