# IF THEN formula

1. ## 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%.

Thank you.

2. ## 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.

3. ## 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%

Thank you

4. ## 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. ## 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. ## 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. ## 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. ## Re: IF THEN formula

Yes, I saw the comma too. Good luck

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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