View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smw2340 smw2340 is offline
external usenet poster
 
Posts: 6
Default calculating a % attainment when base number is negative

I want to write a formula that calculates the percent attainment of a goal
i.e. profit goal. If i have a goal of $-100 and actually attain $100
(positive) profit. What is the formula to write such that the resulting %
does not contain a negative? Additionally, would like the same formula to
take into account if goal is $-100 and actually attain $-60, the % attainment
should be positive.

any advise?