+ Reply to Thread
Results 1 to 3 of 3

Double IF formula - Help!

Hybrid View

  1. #1
    Registered User
    Join Date
    03-27-2012
    Location
    Bournemouth
    MS-Off Ver
    Excel 2007
    Posts
    4

    Double IF formula - Help!

    Hi

    I have been racking my brains on how to do this, I'm not even sure if it's an IF formula I need.

    I've attached a spreadsheet and its a basic report that is comparing this year with last year's figures. I have a column for 2012, another for 2011, a variance column and a percentage variance column.

    The problem is the formula in the variance percentage column. The formula is fine when there are figures shown in both 2012 and 2011 but when there is a zero in either, the #DIV/0! shows up.

    Now, I have put a formula in to say that if the number is zero in 2012 column then put in '0'. It works. However, if there is a zero in the 2011 column because my IF formula doesn't include a condition for this it will show #DIV/0!.

    With me so far? Sorry, I hope I'm explaining this well..

    So I'm guessing I need to add another IF formula but I have tried various things including adding two IF's together but none of them work.

    I've given an example in the spreadsheet attached. I would like cell I14 to show '0%' . If anyone can shed some light on this that would be great. Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Double IF formula - Help!

    Try instead, in I13:

    =IF(OR(F13=0,G13=0),0,H13/F13)

    copied down
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    03-27-2012
    Location
    Bournemouth
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Double IF formula - Help!

    Amazing NBVC!

    Thank you, so much

+ 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