| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set a minimum result value in an Excel formula? IE 100
I need to set the result column of a calculation in Excel to always give me a
result greater than 100, or of 100 or greater. How can I set the formula in the result cell to always finish with a result 100. I am aware this will create a circular reference and I know how to set that up in Excel. I want it to keep rolling over results untill it goes over 100. Then stop at 100 or more. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I round up a result of a formula in Excel | Excel Worksheet Functions | |||
| Convert number into words | Excel Discussion (Misc queries) | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Spellnumber | Excel Worksheet Functions | |||
Linear Mode
