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,
As m_tarler has said, ROUND could work. I would probably consider creating an IF formula, prescribing, as precisely as you can or need to, the min and max of your "super small" label.
But first, before you go monkeying with valid results, even if small and negligible, it would be appropriate to describe a bit more of the context. Depending on that context, even "small numbers" can have serious consequences when ignored, even if only temporarily.
yes any of the ROUND functions could work. maybe ROUND(-2.22044604925031E-16, 15) if you want only really small amounts to round off
