MRound

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to format cells to automatically round a number, for example:

1.37 to 1.25 or 1.38 to 1.50

I have used the mround formula when work with two different cell, i.e.,
in cell b2 I use this formula: =mround(a2,.25) and it works.

However, I would like use the format page (cntl+1) to do it automatically in
the cell I am working. Any help would be great. Thanks.
Johnnie
 
Format will not round to quarter points. It can only round to a specified
decimal point. If you need to round to quarters, you're stuck with using Mround.
 
Fred,
Thanks for the help. I thought that there probably was not a way, but you
never know until you ask the experts.
Johnnie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round Down to the nearest multiple 2
MROUND time 2
MROUND 4
Why doesn't MROUND work? 2
Round time up to nearest :15 2
Round Number to Nearest 50 3
MROUND(F2,TIME(0,0,5)) 2
Round formula 1

Back
Top