| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change no. of decimal places displayed depending on cell va
I have a spreadsheet that calculates ingredient wieghts based on the number
of 14 ounce bottles of sauce to be produced. Weights are expressed in pounds. I would like to display weights as follows: If the value is less than 5 pounds, display 3 decimal places; if the value is 5-10 pounds, display 2 decimal places; if the value is greater than 10 pounds, display 1 decimal place. I would appreciate any help with how to do this. Conditional formatting does not apply. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automaticallychanging the number of decimal places displayed | Excel Discussion (Misc queries) | |||
| how do I change default decimal places? | Excel Discussion (Misc queries) | |||
| How to change decimal places in balance sheet template | Excel Worksheet Functions | |||
| How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) | |||
| DECIMAL PLACES DISPLAYED | Excel Programming | |||
Linear Mode
