Rounding to point 5

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

Guest

I would like help in writing a formula to round to .5. an example is:

a cell has a calculated value of between, 78.75 to 79.25 should round to 79
if the cell has a calculated value between 79.26 and 79.74, it should round
to 79.5

Thanks,

Regards,

Art
 
This worked fine and will fit the need.

Thanks PEO

David, your formula returned a NAME? error that I couldn't identify

Thanks to both of you
 
And did you look at what Excel help said about the MROUND function?
--
David Biddulph

David, your formula returned a NAME? error that I couldn't identify
Click to expand...
....
 

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

Rounding Time to Nearest 5 Minutes 1
Round Function 5
Excel Stop Excel from displaying rounded values 4
Calculate to the third decimal and round up or down in cell 6
How to round down a value to the inferior multiple of 5 3
Rounding Negative Numbers to Zero 4
How to round & sum only the displayed (rounded) numbers 2
TimeSheet Using 100 Minutes & Rounding to .25 2

Back
Top