Rounding off in peculiar cases
I have to do some work calculations. The increment of an employee is 3p.c. of Band Pay Plus Grade Pay. If the integral part of the result is a multiple of ten and the fractional part is less than .50, then the increment gets rounded to the integral part alone. But if the Integral part is any other than a multiple of 10 then the increment gets rounded off to the next higher 10 rupees. How can I write a formula for this?
Perhaps...
=CEILING(A1-(TEXT(MOD(A1,1),"0;;1")+0<0.5),10)
If you can give us a before & after examples, would be helpful.
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks