Forum Discussion
Turn a super small into 0
Hi, Can anyone help me to treat a super small number such as -2.22044604925031E-16 as 0 instead of some number in Excel? I am wondering will ROUND function work or not? Thanks,
yes any of the ROUND functions could work. maybe ROUND(-2.22044604925031E-16, 15) if you want only really small amounts to round off