Results 1 to 6 of 6

An ugly % variance formula needs help to be pretty

Threaded View

Nobleks An ugly % variance formula... 06-15-2020, 02:07 PM
Limor_OP Re: An ugly % variance... 06-15-2020, 02:30 PM
Nobleks Re: An ugly % variance... 06-15-2020, 02:50 PM
loginjmor Re: An ugly % variance... 06-15-2020, 04:21 PM
Nobleks Re: An ugly % variance... 06-15-2020, 05:41 PM
loginjmor Re: An ugly % variance... 06-15-2020, 05:58 PM
  1. 06-15-2020, 02:07 PM #1
    Nobleks is offline
    Registered User
    Join Date
    09-26-2019
    Location
    Phoenix, AZ
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2303 Build 16.0.16227.20202) 64-bit
    Posts
    78

    An ugly % variance formula needs help to be pretty

    I have an ugly formula for percent variance that I have been trying to clean up for a financial report, but I'm hitting walls with it. One big wall is making sure that google sheets likes it too.

    I would love some help and insight (other than using C-4...I've already thought of that.)

    Thank you,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Take the variance of two cells than add back the variance without circular reference
    By scruz9 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2016, 09:07 PM
  2. Need optimize the macro (works well, but the code visually looks pretty ugly - i think so)
    By Remphan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2016, 06:54 PM
  3. toggle between variance in units and % variance
    By ammartino44 in forum Excel General
    Replies: 3
    Last Post: 06-03-2014, 07:21 PM
  4. [SOLVED] Find the date of a variance amount over a limit and count the days since the variance.
    By avidcat in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-21-2013, 12:00 PM
  5. Price Variance and Dollar Variance for multiple stores on certain products
    By hutchgeo4 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-22-2013, 05:49 PM
  6. SUMPRODUCT formula:pretty simple formulae
    By BUSJEDWA in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2008, 08:59 AM
  7. [SOLVED] Pivot Tables - Variance and % Variance fields
    By CraigS in forum Excel General
    Replies: 5
    Last Post: 01-05-2005, 09:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1