Forum Discussion

ajmal_pottekattil_yoousuf's avatar
Feb 16, 2023

Significant Figure rounding issue

in online and excel value getting different

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

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

Resources