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
Expressing a decimal, the formula in cell D4 copied to cell D8 is
Notice the results in range B4:B8 are the same as the results in range D4:D8.
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
Expressing a decimal, the formula in cell E4 copied to cell E8 is
Notice the results in range C4:C8 are the same as the results in range E4:E8.
#evba #etipfreeExpressing 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
Hi, I'm Mr KING Admin of KINGEXCEL.INFO .Thank you so much and I hope you will have an interesting time with KINGEXCEL.INFO. Mail: quantriexcel@gmail.com - PHONE : +84779313987.