M
Michael J. Malinsky
Try:
=MROUND(A1,0.05)
A1 refers to the cell of the info. Change as necessary. MROUND may be an
add-in so if it doesn't work at first go to Tools>Add-ins and select the
Analysis Toolpak
HTH
--
Michael J. Malinsky
Pittsburgh, PA
"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain
=MROUND(A1,0.05)
A1 refers to the cell of the info. Change as necessary. MROUND may be an
add-in so if it doesn't work at first go to Tools>Add-ins and select the
Analysis Toolpak
HTH
--
Michael J. Malinsky
Pittsburgh, PA
"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain