Forum Discussion
ajmal_pottekattil_yoousuf
Feb 16, 2023Iron Contributor
Significant Figure rounding issue
in online and excel value getting different
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.
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.