For some reason when i use round down function, it only rounds down properly if they are whole even numbers.
If the value is exactly 23, round down gives me 22?
If the value is exactly 24, round down gives me 24.
Im trying to round down to any number for example.
23.1 should round down to 23.
Likewise 23.9 should round down to 23.
Not sure what is going on here?
I think i have attached the file. Formula values are in blue.
Bookmarks