I need to round up the sum of a column figures to the next nearest quarter.
For example: $1.11 would be rounded to $1.25, or say $1.83 would be rounded to $2.00.
What formula would I need to do this?
I'm using Excel 2000
Thank you.
I need to round up the sum of a column figures to the next nearest quarter.
For example: $1.11 would be rounded to $1.25, or say $1.83 would be rounded to $2.00.
What formula would I need to do this?
I'm using Excel 2000
Thank you.
Last edited by LS Flowers; 04-02-2009 at 12:32 PM.
coffee man
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks