| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Threaded Mode
