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_uTdoOdEgTcAXSOMpTxPMePIxviyuC0OWFHI0-jJTFGVO0p0fMLn_TuH56GWF7n27kCcT93y9sOsP0566acPrUyxSEpKmS4QIT5a3uuiRzxlGlbXIhXcKUEijxWC0aIWmaKZxFJY78N0nANm9euXf1DvQ=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_sZmtfQ-FTSahm2O0WrHL3UobR7H3Y28koiNMNnIaFTNeTVE0AY3TWma_9LWzm_KywqV9fL2nTTiV37SWBIwxspfeUrRr7sfRLrCpRV610-PLslNg4dK6y5u6PiasR1pYI0j0yjoAbr3Hjr47i8jqblkElS=s0-d)
#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
No comments:
Post a Comment