Rounding Numbers By Fractions or Decimals - KING OF EXCEL

Wednesday, December 18, 2019

Rounding Numbers By Fractions or Decimals

Rounding Numbers By Fractions or Decimals
When rounding numbers to a particular decimal factor, you can express that rounding factor in your formula as either a fraction or as its decimal equivalent. In the pictures, the fraction one-eighth can be stated in a formula as 1/8 or by its decimal equivalent of .125.
Rounding up
Expressing a fraction, the formula in cell B4 copied to cell B8 is =CEILING(A4,1/8)
Expressing a decimal, the formula in cell D4 copied to cell D8 is =CEILING(A4,0.125)
Notice the results in range B4:B8 are the same as the results in range D4:D8.
Rounding down
Expressing a fraction, the formula in cell C4 copied to cell C8 is =FLOOR(A4,1/8)
Expressing a decimal, the formula in cell E4 copied to cell E8 is =FLOOR(A4,0.125)
Notice the results in range C4:C8 are the same as the results in range E4:E8.
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

Popular Posts