Min Formula

[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?

 

[Pete_UK]

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

 

[Dave Peterson]

You could use:

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

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

 

[Mike H]

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.