+ Reply to Thread
Results 1 to 3 of 3

Adding Another IF statement to a Formula

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    466

    Unhappy Adding Another IF statement to a Formula

    Hi,

    I have a formula with two IF statements and would like to add a third and fourth i.e.


    Please Login or Register  to view this content.

    The first IF in the formula checks the value in cell J10 and if it is less or equal to10% than the value F10 a message will be displayed i.e. ‘Warning 10% or less Budget Remains!’.

    The second IF in the formula checks the value in cell J10 and if it is less or equal to 20% than the value F10 a message will be displayed i.e. ‘Warning 20% or less Budget Remains!’.

    What I would like for the third IF statement to check if the value in cell J10 and if it is equal to F10 a message will be displayed i.e. ‘No Budget Remains!’.

    What I would like for the fourth IF statement to check if the value in cell J10 and if it is greater than F10 a message will be displayed i.e. ‘You have Exceeded Your Budget!’.


    Any help would be great appreciated as I’ve tried and cannot get the syntax correct


    Many thanks in advance


    Rob

    NB Excel version 2003
    Rob

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Adding Another IF statement to a Formula

    Are you sure? The third criterion doesn't seem to make sense...
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

  3. #3
    Registered User
    Join Date
    08-16-2010
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Adding Another IF statement to a Formula

    As mentioned above, not really sure what this is suppose to do for you but below code would do as you said.
    =IF(J10="","",IF(J10<=F10*0.1,"Warning 10% less of the budget remains!",IF(J10<=F10*0.2,"Warning 20% less of the budget remains!",IF(J10=F10,"No Budget Remains!",IF(J10>F10,"You have exceeded your budget!","")))))

+ 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