Forum Discussion
question
Can I put a minimum and a maximum number, that a cell with a formula, can have?
lfox2 Learning to provide concrete examples will go a long way toward getting applicable answers.
Suppose the original formula is =SUM(A1:A100), and you want the result to be no less than 10 and no more than 100. You could write:
=MAX(10, MIN(100, SUM(A1:A100))