Results 1 to 2 of 2

Nested IF logic

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2010
    Location
    London,England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Nested IF logic

    Hi Everyone

    I am desperately trying to figure out a formula that says

    if one cell is more than 10% larger than the other then say increased, if it is more than 10% lower say decreased and if not say same ( Essentailly I only want to show change if it has been more that 10% in either direction.

    this is my attempt that is not working !

    =IF(E8-D8<10%,"Increase",IF(E8-D8>10%,"Decrease",IF(E8=D8,"Same",)))

    With this formula I get these results, which i think are correct for the increase and desrease but if they are the same im getting 'increase'

    100% 18% Increase
    100% 100% Increase
    100% 91% Increase
    100% 82% Increase
    70% 100% Decrease
    100% 100% Increase
    60% 82% Decrease
    33% 73% Decrease
    83% 73% Increase
    33% 73% Decrease
    100% 100% Increase
    90% 100% 0
    50% 100% Decrease
    70% 100% Decrease

    Plesae help Im driving myself nuts trying to use this formula. I have never been trained in Excel and learn as I go but this time i am confused !!!

    Thank you
    Claire
    Last edited by DonkeyOte; 12-11-2010 at 06:11 AM. Reason: revised title

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