Forum Discussion
Solved
Excel Formula with a max limit
Hi, I am trying to figure out a formula to calculate 25% of a particular cell until the outpul cell reaches a certain total. e.g calculate 25% of C11 until the output totals $5,000. Then the outp...
Somewhat ironically, what you need is the MIN function.
=MIN(5000,C11*.25)
The largest this will go to is 5000; so long as one quarter of C11 is less than 5000, it will yield that lower number.
Somewhat ironically, what you need is the MIN function.
=MIN(5000,C11*.25)
The largest this will go to is 5000; so long as one quarter of C11 is less than 5000, it will yield that lower number.
- LOL........I am starting to learn something more than the very basic in excel so I thought I needed a max formula. Thank you so very much!! It works :)) Thank you for the quick help!! Good day to you!!
