Min Formula
 

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?

Min 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

On Mar 10, 2:28*pm, Canon wrote:
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?

Min Formula
 

You could use:

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

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

Canon wrote:

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?

--

Dave Peterson

Min Formula
 

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.


"Canon" wrote:

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?