Posted: 12/11/2008 8:04:41 AM EDT
|
If you need to round a cell to a specified multiple, you use the MROUND function.
The problem is, MROUND rounds to the nearest multiple (which sometimes rounds up, sometimes rounds down). I need to round up to a specified multiple. I cannot figure out how to do it. Can the arfcom mind help? |
|
Hmmm, can't figure it out. I tried combining the Mround and Roundup function but that didn't work.
You could do it a simple way. Take the amount, divide by the multiple. Take the result and round it up to zero decimal places and then take that amount and multiply it by your multiple. Stupid but it should work. |