Skip to main content
added 185 characters in body
Source Link

I'm trying to round numbers on excel based on a range. If the number is < 10 and > 0.5, I want it to round to one decimal place. When the number is 0.968, it rounds to 1. It does not show the zero after the decimal. How do I change the formula so that it shows the zero (i.e. 1.0)?

=IF(B11>=10, ROUND(B11,0), IF(AND(B11<10, B11>0.5), ROUND(B11,1), IF(B11<=0.5,ROUND(B11,0)))) Edit: If the number is <0.5, I want it to to round and show 2 decimal places. Formatting the cells to show only one decimal place would prevent me from seeing the 2nd decimal place.

=IF(B11>=10, ROUND(B11,0), IF(AND(B11<10, B11>0.5), ROUND(B11,1), IF(B11<=0.5,ROUND(B11,2))))

I'm trying to round numbers on excel based on a range. If the number is < 10 and > 0.5, I want it to round to one decimal place. When the number is 0.968, it rounds to 1. It does not show the zero after the decimal. How do I change the formula so that it shows the zero (i.e. 1.0)?

=IF(B11>=10, ROUND(B11,0), IF(AND(B11<10, B11>0.5), ROUND(B11,1), IF(B11<=0.5,ROUND(B11,0))))

I'm trying to round numbers on excel based on a range. If the number is < 10 and > 0.5, I want it to round to one decimal place. When the number is 0.968, it rounds to 1. It does not show the zero after the decimal. How do I change the formula so that it shows the zero (i.e. 1.0)?

Edit: If the number is <0.5, I want it to to round and show 2 decimal places. Formatting the cells to show only one decimal place would prevent me from seeing the 2nd decimal place.

=IF(B11>=10, ROUND(B11,0), IF(AND(B11<10, B11>0.5), ROUND(B11,1), IF(B11<=0.5,ROUND(B11,2))))
Source Link

Show trailing zero after round function

I'm trying to round numbers on excel based on a range. If the number is < 10 and > 0.5, I want it to round to one decimal place. When the number is 0.968, it rounds to 1. It does not show the zero after the decimal. How do I change the formula so that it shows the zero (i.e. 1.0)?

=IF(B11>=10, ROUND(B11,0), IF(AND(B11<10, B11>0.5), ROUND(B11,1), IF(B11<=0.5,ROUND(B11,0))))