Forum Discussion
How to made a limit value at 10 and after that don't count even if I add more value in cell
Help please! I need a formula with... Ex. Limit apple bucket at 10 If I buy 11 apple it have to limit at 10. If I sell 3 apple it have to count 7 apple not 9. Buy more 5 count to 10 not 12 but ...
Perhaps like this:
Formulas:
The formula in A3 is
=MAX(MIN(A2+B2-C2, 10), 0)
This has been filled down.