Prev: how to perform function (e.g. Sum, Average) on VB 3-d Array
Next: Loop in Excel
From: John A. John on 6 May 2010 18:55
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
From: Dave Peterson on 6 May 2010 19:31
=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
From: Rich Locus on 6 May 2010 19:33
John:

I don't think this is a programming question, but you can use the Round
Function as in this example:

=ROUND(B3/A3,0)

When creating the formula, just start with the =ROUND(
Then use your mouse to click the cells, and when finished, use zero as the
number of places to round.

Regards,
--
Rich Locus
Logicwurks, LLC


"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
From: John A. on 6 May 2010 20:19
This was exactly what I needed Rich. Worked great.

Thanks!!!

"Rich Locus" wrote:

> John:
>
> I don't think this is a programming question, but you can use the Round
> Function as in this example:
>
> =ROUND(B3/A3,0)
>
> When creating the formula, just start with the =ROUND(
> Then use your mouse to click the cells, and when finished, use zero as the
> number of places to round.
>
> Regards,
> --
> Rich Locus
> Logicwurks, LLC
>
>
> "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
From: John A. on 6 May 2010 20:21
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
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: how to perform function (e.g. Sum, Average) on VB 3-d Array
Next: Loop in Excel