| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a maximum field value to 100%
I'm calculating percentages... is there a way to set the maximum to
100% ? That is, if the calculation were 130%, Excel would know to use 100%. Is there a better way than an IF, THEN statement? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting the minimum/maximum display range of a chart | Excel Discussion (Misc queries) | |||
| mailmerge maximum field size | Excel Discussion (Misc queries) | |||
| pivottable formula : maximum one field - minimum of another one | Excel Discussion (Misc queries) | |||
| Setting Maximum number of Workbooks per Instance of Excel | Excel Programming | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Linear Mode
