View Single Post
  #1   Report Post  
BigDon
 
Posts: n/a
Default Excel % Variance Formula........

How do I formulate negative variance formulas? Example: 2005 (-) 500
2004 (-) 400 Variance =(-) 100 Variance % (-)100/(-)400 =25%
I want a formula that gives me (-) 25%.........not positive.......

If formula????