Calculation limit

[dekueb]

I have a simple formula in C1 like =A1*B1

What have I to add that when a certain value is reached it dont take the calculation in consideration but the max value.

EX. In A1 (25); in B1 (36); in C1 with the formula A1*B1 = 900.
So far so good. But in a next calculation I use C1 as reference, but I can only have a max of 700.
So the next calculation should not be 900 but 700. If the value is less than 700 than of course take the value of C1

Thanks for your reply

[Glenn Kennedy]

Try this:

=MIN(700,A1*B1)

[dekueb]

Great Glenn.
I can work with that.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.