Excel formula needed to round up a value to a whole number
Be aware that there is a difference on how those two functions work.
Try it with:
=round(1.1,0)
and
=roundup(1.1,0)
I'm not sure which you want.
John A. wrote:
yours worked too Dave.
Thanks!!!
"Dave Peterson" wrote:
=roundup(a1,0)
or
=roundup(a1/a2,0)
John A. wrote:
I'm making a cost estimation sheet, and need a cell to publish a whole
number. This cell is the result of a division formula involving two other
cells (ie. 300 sq ft of coverage divided by 200 sq ft of coverage per gallon
= 1.5 gallons). I want my formula to round the 1.5 gallons up to 2 gallons.
Please help!
Thanks,
John
--
Dave Peterson
.
--
Dave Peterson
|