Min Formula

  • Thread starter Thread starter Canon
  • Start date Start date
C

Canon

Excel 2007
I have a very simple formula;
=sum(Errors!26)
I would like to have a minimum value in the destination cell of 750.00,
would would I have to add to this formula?
 
I don't understand the formula that you have, so perhaps it's a typo,
but you can do this:

=MAX(750,your_formula)

so that if your formula is less than 750 the MAX returns 750, and if
your formula is larger than 750 then that value will be returned.

Hope this helps.

Pete
 
You could use:

=if(yourrealformula<750,750,yourrealformula)
or
=max(750,yourrealformula)

(But that doesn't look like a good formula to me.)
 
Hi,

What is Errors!26


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top