Which formula in B1 returns the number from A1, with two decimals, rounded in the following way:
If the decimals are anywhere between ,01 and ,49 ----> ,50
If the decimals are anywhere between ,51 and ,99 ----> ,00 (+1)
For example:
3,34 ---> 3,50
2,79 ---> 3,00
12,02 ---> 12,50
Thanks!
Bookmarks