Significant Figure rounding issue

Frequent Contributor

in online and excel value getting different

1 Reply
best response confirmed by ajmal pottekattil yoousuf (Frequent Contributor)

@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.