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?