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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I display a minimum or cell value? 2
Conditional Formatting Minimim Value 2
Min Formula 3
Conditonal formatting problem! 1
Finding minum positive from the result of formula 8
Minimum non-zero value 3
How do I set a minimum value to be returned from IF function 1
set a minimum value for a cell 5

Back
Top