how do I round a column of numbers to the nearest
Hi,
Depending on exactly what you mean,
Look at each of these:
ROUNDUP(X,2)
CEILING(X,2)
MROUND(27.51,.50) rounds to the nearest 50 cents.
If this helps, please click the Yes button,
Cheers,
Shane Devenshire
"Suzy" wrote:
How do I round a column of numbers up or down? ei. $27.51 = $27.50 and
$29.24 = $29.25?
|