rounding to the nearest quarter

G

grandma13

I have a cell that contains a formula which results in a
number with 2 decimal places. I need to add to the
formula to make the answer round to the nearest quarter.
like: 1.41 would become 1.50, 1.12 would become 1.00,
1.13 would become 1.25, 1.68 would become 1.75 and 1.80
would become 2.00
Please help!!
 
N

Norman Harker

Hi Grandma13!

Use:
=ROUND(A1*4,0)/4

Or there is an Analysis ToolPak function:

=MROUND(A1,0.25)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
G

grandma13

That works perfect!! Thanks so much!
-----Original Message-----
Hi Grandma13!

Use:
=ROUND(A1*4,0)/4

Or there is an Analysis ToolPak function:

=MROUND(A1,0.25)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

"[email protected]"
Click to expand...
 
N

Norman Harker

Hi Grandma13!

Always pleased to help; especially Grandmothers!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top