+ Reply to Thread
Results 1 to 8 of 8

IF THEN formula

  1. #1
    Registered User
    Join Date
    11-06-2014
    Location
    ANAHEIM,CA
    MS-Off Ver
    2007
    Posts
    4

    IF THEN formula

    Hello,
    If a cell in a column is TRUE I want each cell in a row to increase by 6%. I.e. IF Q5 is True then the value in each cell I7:O7 should increase by 6%.

    Please help.

    Thank you.

  2. #2
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: IF THEN formula

    Sounds confusing. So you will have numerical values in cells I7:O7 and a value that is either TRUE or FALSE in Q5. If the value is TRUE then all values in range I7:O7 increase by 6%. I believe this is not possible with a formula because you can't have a formula and a numerical value in the same cell, can you? A macro can do this.

    Perhaps not exactly what you need, but might give you an idea.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-06-2014
    Location
    ANAHEIM,CA
    MS-Off Ver
    2007
    Posts
    4

    Re: IF THEN formula

    Play Prep chart build to.xls

    Hello,
    Maybe the sheet will show what I'm trying to accomplish. If the checkbox is toggled the I would like the values in the Tues through Mon row to increase by 6%

    Any advice is appreciated.

    Thank you

  4. #4
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: IF THEN formula

    I believe you have already gotten most of the formula right in S7, you just need to replace the I7 with the actual value of the cell, which is G7*(F5+G5+H5)%/9 I assume and add the value for ELSE clause. So the full formula looks like this:

    =IF(Q7=TRUE;G7*(F5+G5+H5)%/9+G7*(F5+G5+H5)%/9*0.06;G7*(F5+G5+H5)%/9)

    If you add that formula to I7 it will change back and forth, depending on whether you tick or untick B7.

  5. #5
    Registered User
    Join Date
    11-06-2014
    Location
    ANAHEIM,CA
    MS-Off Ver
    2007
    Posts
    4

    Re: IF THEN formula

    Hello,
    The previous formula worked. Much thanks. I have another problem. I now need to have a second formula added to the same cell which will be used instead of the first if a different checkbox is ticked.

    =IF(Q7=TRUE;G7*(F5+G5+H5)%/9+G7*(F5+G5+H5)%/9*0.06;G7*(F5+G5+H5)%/9) or =IF(R7=TRUE,G7*(F5+G5+H5)%/9-G7*(F5+G5+H5)%/9*0.06;G7*(F5+G5+H5)%/9)

    How do I join them in the same cell. I've tried and no luck.

    Thanks

  6. #6
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: IF THEN formula

    If the 1st box is ticked it uses the 1st formula without additional checking. If the 1st box isn't ticked it checks if the 2nd box is ticked, and if it is the 2nd formula is used.

    =IF(Q7=TRUE;G7*(F5+G5+H5)%/9+G7*(F5+G5+H5)%/9*0.06;IF(R7=TRUE;G7*(F5+G5+H5)%/9-G7*(F5+G5+H5)%/9*0.06;G7*(F5+G5+H5)%/9))

  7. #7
    Registered User
    Join Date
    11-06-2014
    Location
    ANAHEIM,CA
    MS-Off Ver
    2007
    Posts
    4

    Smile Re: IF THEN formula

    Hello,
    Your help is much appreciated. All I had to do was change one character and it worked fine. My mistake was I tried to combine the formulas with text and all it needed was a comma.

    Thanks again

  8. #8
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: IF THEN formula

    Yes, I saw the comma too. Good luck

+ 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. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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