+ Reply to Thread
Results 1 to 2 of 2

Excel IF statement based on percentage variance

  1. #1
    Registered User
    Join Date
    11-25-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2013
    Posts
    13

    Excel IF statement based on percentage variance

    Ok so what I’m trying to do (see column L) is say, if Hospital B’s ALOS (average length of stay) is 10% higher than Hospital A then put “higher”; if 10% lower then put “lower”; but if it’s within 10% either side (high or low) then I want it to say “equivalent”. BUT also, some might not h![enter image description here][1]ave episodes at both sites so ALOS = 0 so ignore in that and put “xyz”

    Current formula is: =IF(G7=E7+L1,"Equivalent ALOS",IF(G7=E7-L1,"Equivalent ALOS",IF(G7>E7+L1,"Higher ALOS than Eastern",IF(G7<E7-L1,"Lower ALOS than Eastern","N/A"))))



    formula.PNG

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Excel IF statement based on percentage variance

    Please post a small sample file to work with as images (often) can not be viewed

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Variance or Percentage Change?
    By HangMan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2015, 01:30 PM
  2. Formula for Convert Variance to a Percentage Using SUMPRODUCT
    By HangMan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-01-2015, 03:06 PM
  3. Convert Variance to a Percentage Using SUMPRODUCT
    By HangMan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-01-2015, 02:33 PM
  4. Percentage Variance Graphs
    By Bobo6782 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-04-2014, 07:00 AM
  5. How do I obtain a variance percentage? Please check my calculation/formula
    By Dixiewest in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-12-2013, 02:58 PM
  6. Replies: 1
    Last Post: 04-16-2013, 03:58 PM
  7. Conditional Formatting using Percentage Variance
    By Skarnald in forum Excel General
    Replies: 3
    Last Post: 02-09-2012, 11:03 PM

Tags for this Thread

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