Prev: how to perform function (e.g. Sum, Average) on VB 3-d Array
Next: Loop in Excel
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 3-d Array
Next: Loop in Excel