+ Reply to Thread
Results 1 to 3 of 3

If formula to calculate percentage up or down?

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    Isle of Man
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    82

    If formula to calculate percentage up or down?

    Sorry this probably has a really simple solution but I'm getting stuck..

    I'm checking the percentage difference between A1 and B2 (the result of this is in C2). I need a formula which will show - if the percentage is above 10% or below -10% then it will say "Tolerance High." If the percentage is below 10% or above -10% then it will say "Tolerance fine."

    Does this make sense at all? Many thanks for any help!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: If formula to calculate percentage up or down?

    ="Tolerance "&IF(ABS(C2)<10%,"fine","High")
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    11-25-2014
    Location
    Isle of Man
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    82

    Re: If formula to calculate percentage up or down?

    This worked perfectly, thank you!

+ 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. formula to calculate percentage
    By lizsantiago07 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2012, 01:43 PM
  2. Formula to calculate percentage?
    By smartcard in forum Excel General
    Replies: 4
    Last Post: 06-13-2010, 12:29 PM
  3. auto-calculate percentage formula
    By Jeebs in forum Excel General
    Replies: 2
    Last Post: 07-03-2008, 02:54 PM
  4. Formula to calculate percentage sales
    By stokie21 in forum Excel General
    Replies: 3
    Last Post: 12-13-2007, 06:42 PM
  5. [SOLVED] How do I create a formula to calculate the average percentage rat
    By LD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-13-2005, 03:06 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