+ Reply to Thread
Results 1 to 2 of 2

percentages in excel?

  1. #1
    Registered User
    Join Date
    11-06-2015
    Location
    Lancashire
    MS-Off Ver
    2013
    Posts
    19

    percentages in excel?

    Surely this has to be easy, but it isn't.

    I want to compare the % difference between two years. But:
    > if one cell is blank then the calculator needs to be blank.
    > if the first year is 0 then the 2nd year has a positive value then I need it to say 100%
    > if both years are 0 then it needs to say 0%
    > if both have a value then needs to work out the %.

    this is the formula but it still struggles.

    =IF(B2="","",IF(B2&C2=0,0,(B2-C2)/C2))

    ps how do I say the post is sorted

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL (COVID allowing)
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,402

    Re: percentages in excel?

    How about this?
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Regarding your 'ps' - if you mean 'how do I mark the thread as solved' - see my sig.
    Regards,
    Aardigspook

    Recently moved house, internationally, during COVID (!) so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

+ 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. [SOLVED] Sum monthly percentages into quarterly percentages
    By Zyphon in forum Excel General
    Replies: 6
    Last Post: 06-11-2015, 04:40 AM
  2. Reversing input percentages against variable percentages.
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-26-2014, 08:56 PM
  3. Percentages in excel
    By loulibelle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2013, 08:11 AM
  4. [SOLVED] Excel Chart with percentages
    By fiorella1985 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-27-2012, 11:49 AM
  5. Excel 2007 : Excel percentages
    By Gloria Felder in forum Excel General
    Replies: 10
    Last Post: 05-10-2012, 02:56 PM
  6. percentages in excel
    By AGREENE16 in forum Excel General
    Replies: 2
    Last Post: 01-24-2009, 04:45 PM
  7. [SOLVED] Percentages in Excel
    By Karl in forum Excel General
    Replies: 5
    Last Post: 02-08-2006, 10:40 AM

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