What is JIS rounding?
JIS rounding is the process of making the upper one digit an even number when the target to be rounded is “5”.
This method is described in “JIS Z 8401” as a method to reduce errors even if the rounding process is repeated.
How to achieve JIS rounding (bank rounding) in Excel
JIS rounding in Excel can be achieved by using the following formula.
EXCEL=IF
(ABS(ABS(A1*100-INT(A1*100)-0.5))*1E-15,INT(A1*50 0.5)/50,ROUND(A1,2)) MEMO
The number of digits can be changed by changing “1E-15” in the formula.… “1E-(number of decimal places)]
