How Do I set a minimum(or default) value a a result from formula

I would like to know if there is a way to have a minimum value result from a
formula . For example I want the minimum handicap to be displayed in a cell
as a 6 so anytime that the sum of the formula is less than 6 (like 1, 2, 3
etc.) 6 would be entered automaticall and any value at 6 or above will
display its true value.

Hi!

Try this:

=MAX(6,your_formula)

Biff

"Gr89ballr" <[email protected]> wrote in message
news:[email protected]...
>I would like to know if there is a way to have a minimum value result from
>a
> formula . For example I want the minimum handicap to be displayed in a
> cell
> as a 6 so anytime that the sum of the formula is less than 6 (like 1, 2, 3
> etc.) 6 would be entered automaticall and any value at 6 or above will
> display its true value.