![]() |
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