LinkBack URL
About LinkBacks
Hi all,
Cell B9 needs to show � saving up to and including 8%. The % fluctuates below and above 8% but I need it to limit the result to a maximum of 8%. The result needs to be displayed as �.
Thank you all
Formula to show saving up to a cut off point
Hi all,
Cell B9 needs to show � saving up to and including 8%. The % fluctuates below and above 8% but I need it to limit the result to a maximum of 8%. The result needs to be displayed as �.
Thank you all
Last edited by Oliver3443; 05-16-2024 at 07:10 AM.
What's the calculation? How do you calculate the saving?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Is this what you need?
=IF(B8>8%,(B7/B8)*8%,B7)
Hi Ali, the saving is calculated as a difference between the budget prod and the achieved prod. (prod means rate). CTE is the hourly pay rate. The total saving is the actual correct amount but I need the result to show up to and including 8%. The result should be static for anything over 8%. I have included the formulas for calculation in the cells.
Hi, I have found the answer.
= MIN(B7, 0.08 * B4)
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.
Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
Actually it doesnt work. Ill keep looking
I'm pretty sure the formula I suggested does what you stated in post #4 - did you try it?
Hi,
Yes I tried it, when I put the base as 100 and the new rate as 108, to indicate an 8% increase, I expected the result to be the highest I will see. If I increase to 108.1 or above the result changes and continues to change as I increase the new rate. Im looking at what it considers to be 8%, whether its an increase of 8% of the original number or a reflection of the new.
Provide a workbook with a few WORKED EXAMPLES set up manually to illustrate what you want. I am not clear from your description about the calculation required (in fact, I am not sure that you are, either).
I figured it out. Two separate formulas, one with the max 8% and a MIN comparison to chose the lowest.
OK - thanks for letting us know, but that is what my formula does, effectively. I am no closer to understanding why you rejected it, and with no samples as requested, I have no way of troubleshooting it.
The formula you offered does not satisfy the requirement. I need it to show up to 8% then stop. Your solution continues to change when the % increases. I have attached sample2 with the detail
Where are your expected results?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks