software

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

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