Skip to main content
added 373 characters in body
Source Link
Viki Ji
  • 482
  • 2
  • 5

You may only need to set the cell format to Number and the Decimal places to 1.

enter image description here



Update:
Since the particularity of rounding 0.968, I set the format of the part <10 and >0.5 to "0.0".

=IF(B11<0.5,ROUND(B11,2),IF(B11>=10,ROUND(B11,0),TEXT(B11,"0.0")))

enter image description here

You may only need to set the cell format to Number and the Decimal places to 1.

enter image description here

You may only need to set the cell format to Number and the Decimal places to 1.

enter image description here



Update:
Since the particularity of rounding 0.968, I set the format of the part <10 and >0.5 to "0.0".

=IF(B11<0.5,ROUND(B11,2),IF(B11>=10,ROUND(B11,0),TEXT(B11,"0.0")))

enter image description here

Source Link
Viki Ji
  • 482
  • 2
  • 5

You may only need to set the cell format to Number and the Decimal places to 1.

enter image description here