+ Reply to Thread
Results 1 to 2 of 2

Variance Percentage (When Actual and/Or Budget are NEGATIVE) - Favorable or NOT %

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Washington, DC
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Variance Percentage (When Actual and/Or Budget are NEGATIVE) - Favorable or NOT %

    I am working on a spreadsheet that shows: Actual, Budget and Last Year numbers. Then I am showing the Variance in $ and then in %.
    The typical (F29-G29)/G29 formula does not work on a consistent basis. F=Actual and G=Budget. This formula works if both my actual and my budget are "Positive Numbers"
    Example (Revenue)
    Like Actual=$75 and Budget=$55
    The Variance would be FAVORABLE because we bought in MORE revenue than we budgeted for
    Rev
    Act Bud Var
    75 55 36%
    (F58-G58)/G58
    Exp
    Act Bud Var
    75 55 -36%
    (G62-F62)/G62

    BUT…now if I have either a NEGATIVE Budget or a NEGATIVE Actual…or BOTH NEGATIVES –
    What formula can I use to show the REAL Variance and its meaning (favorable or Unfavorable)??
    Attached Files Attached Files
    Last edited by krice929; 04-16-2013 at 02:40 PM. Reason: to add a file

  2. #2
    Forum Contributor
    Join Date
    03-11-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    107

    Re: Variance Percentage (When Actual and/Or Budget are NEGATIVE) - Favorable or NOT %

    I dunno what you mean but the % Error not being real if its negative...

    But if you're looking to get positive % Errors (aka variance) use the following formula. IMHO the signs let you know whether you are below or above your budget with your variance, which is useful.
    =ABS((F2-G2)/G2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1