Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can someone please help explaining to me. We have a need to ROUND DOWN to two decimals and the only way I believe is by using the FLOOR functions. However, it seems to be inconsistent. As you can see below, on some of them it actually drops down 1 decimal. In this case it should not change any of these numbers, or am I missing something here?
Thanks,
Wynand
Use round instead
Something to read:
I cannot use round, I have to ROUND DOWN. So 1.678 becomes 1.67 and NOT 1.68. This is just example data, and I found some inconsistencies in my actual data and started testing, that is why I posted here.
Thanks Sunny,
This is very interesting. I will have a look at some of the workarounds.
Thanks,
Wynand