Significant Figure rounding issue

[ajmal pottekattil yoousuf]

in online and excel value getting different

[#2 · Accepted solution]

@ajmal pottekattil yoousuf 

Your first screenshot shows the number rounded to the nearest value with 2 decimal places.

Your second screenshot shows that you're using ROUNDUP. This doesn't round to the nearest value but to the next higher value. If you want the same result as in the first screenshot, use ROUND instead of ROUNDUP.