Hi!

Try this:

=MAX(6,your_formula)

Biff

"Gr89ballr" wrote in message
...
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.