Thread: Calculating Weighted Average
View Single Post
  #5   Report Post  
sfmoored sfmoored is offline
Junior Member
  
Posts: 4
Default
Quote:
Originally Posted by wickedchew View Post
Yes, that is possible.

The formula should only contain (as for the example):

1 - (Target - Actual)/Target

or

1 - (Actual - Target)/Target
OK, thanks! I believe this is it:
Attached Images
 
Reply With QuoteReply With Quote