Calculations Error.
I am encountering a problem in my excel calculation. I have a salary sheet in which figures come in fractions. There is a catch in this that I have to round them to the previous figure if the fraction falls below .5. But if the fraction goes from .5 above, it should be rounded to the next figure. Not only that, the sum of these figures should reflect the change. Any solution??
Last edited by bchowdhury; 05-04-2005 at 11:53 AM.
Ok...Let's see if I got this right:
I'm guessing that maybe it's not necessary to actually ROUND the amounts up or down, but they must APPEAR rounded. Meaning that 1.6 can be displayed as 2.
If that's true then you can:
Format>Cells>Number Tab
Category: Number
Decimal Places: 0
Then, for the total:
=SUMPRODUCT(ROUND(A1:A20,0))
You'd need to adjust the range to suit your needs.
Does that work for you?
Ron
Calculation error solved.
Dear Mr. Ron
It has worked fine. It has solved a long-standing problem of mine. Thank you very much. Shall come back to you soon with another.
Last edited by bchowdhury; 05-05-2005 at 10:34 AM. Reason: Syntax error.
Thanks for letting me know that worked for you.
Glad I could help.
Regards,
Ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks