rounding to the nearest quarter

  • Thread starter Thread starter grandma13
  • Start date Start date
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!!
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

"(e-mail address removed)"
Click to expand...
 
Hi Grandma13!

Always pleased to help; especially Grandmothers!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top