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.
![RoundUp_Fraction_Decimal](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tQzWL8MV1k_JjnNdTl83E01Jykn_k6996Pxb8zscaF6qS9e_VMCoIHJzECs11ZxaH4uzsJ4GVTsrcr1wbQ0FHnxiYKHM37S1S4Tmvnpq5iWqlQRpILM2Ub2YAU4ugCs9KQhetAiMAR9AdZVlzfloHJKQ=s0-d)
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.
![RoundDown_Fraction_Decimal](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sYL4FN5ql74Z0m1fwoj1YI_1VyE2HhK2VueMSufUwdeMAe98u9r1C7BElurj04HAqgyCYc5BOEkGvv0ijKY16RGr3Yoy10_c-qrJcTJCxJis1HstLv8BM8VOIaX52oBibwf5oI8-6sbbMxstTZvuz69wOl=s0-d)
📤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
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.