Hello friends!
I am currently using the ROUNDDOWN formula to round to the nearest two decimal places.
However sometimes it doesn't work when the last decimal is zero. Instead it rounds to the nearest decimal place.
E.g 70.456 will become 70.46 and 79.10 becomes 79.1. THe issue is that I specifically want to use all two decimals to keep it "neatly formated".
Current fomula:
=ROUNDDOWN(C1*100;2)&";"&ROUNDDOWN(C2*100;2)
What is the underlying mechanics of ROUNDDOWN formula? Is there any better way to solve this?
Many Thanks!
Sinep
Bookmarks