In Excel we can use the FLOOR function to calculate this value.
For example:
Say our price is Rs 4.32 and we need to round it down to the nearest value divisible by 5 cents,
The FLOOR function would read:
=FLOOR(4.32, 0.05)
=Rs 4.30
Categories:
FORMULA
Posts
0 comments:
Post a Comment