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.