ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to change no. of decimal places displayed depending on cell va (https://www.excelbanter.com/excel-programming/355676-how-change-no-decimal-places-displayed-depending-cell-va.html)

fulmodad

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.


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com