From: Dave Peterson on 6 May 2010 20:32 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
First

Prev

Pages: 1 2 Prev: how to perform function (e.g. Sum, Average) on VB 3d Array Next: Loop in Excel 