I am working on a price list and would like to round off to the highest quarter:
27.56 would be 27.75
12.87 would be 13.00
Thanks very much.
I am working on a price list and would like to round off to the highest quarter:
27.56 would be 27.75
12.87 would be 13.00
Thanks very much.
=ceiling(A1, 0.25)
Entia non sunt multiplicanda sine necessitate
Thanks very much!
You're welcome, glad it worked for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks