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.
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.
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.
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
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.
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
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))
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
Yes, I saw the comma too. Good luck
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks