brainteaser?
 

new to this, the answer is probably right in front of me and I don't know it!

I use a speadsheet to calculate several types of daily information. There
are several cells for each day, each with it's own calculations. Towards the
end of the range of cells, I would like one of the final numbers to be
rounded, so that all functions after this work off of the rounded number. Is
there a way to do this without adding an extra column for the rounding
function?

Formula looks like this: =I9*.45

It always gives me a dollar amount with odd cents, and I'd rather have an
even number. How do I make the round function part of this formula.
(as in, if I9 = $65.20, the formula gives me $29.34, where as I would prefer
$29.00)

try formatting the cell you want to currency with zero decimal places.

"nicklissa" wrote:

new to this, the answer is probably right in front of me and I don't know it!

I use a speadsheet to calculate several types of daily information. There
are several cells for each day, each with it's own calculations. Towards the
end of the range of cells, I would like one of the final numbers to be
rounded, so that all functions after this work off of the rounded number. Is
there a way to do this without adding an extra column for the rounding
function?

Formula looks like this: =I9*.45

It always gives me a dollar amount with odd cents, and I'd rather have an
even number. How do I make the round function part of this formula.
(as in, if I9 = $65.20, the formula gives me $29.34, where as I would prefer
$29.00)

On Sun, 13 Mar 2005 19:29:02 -0800, nicklissa
wrote:

=I9*.45

Change the formula to =ROUND(I9*.45,0).

If that is not appropriate, then in the subsequent formulas, do the rounding of
that factor.


--ron

Changing the format does not change the underlying data. If it was 4.758
before, it may display as 4.76, but the value is still 4.758.

To get an even number of dollars, rounded down, it's =INT(I9*.45), or do do
true rounding, =ROUND(I9*.45)


On Sun, 13 Mar 2005 19:55:03 -0800, Dismal
wrote:

try formatting the cell you want to currency with zero decimal places.

"nicklissa" wrote:

new to this, the answer is probably right in front of me and I don't know
it!

I use a speadsheet to calculate several types of daily information. There
are several cells for each day, each with it's own calculations. Towards
the
end of the range of cells, I would like one of the final numbers to be
rounded, so that all functions after this work off of the rounded number.
Is
there a way to do this without adding an extra column for the rounding
function?

Formula looks like this: =I9*.45

It always gives me a dollar amount with odd cents, and I'd rather have an
even number. How do I make the round function part of this formula.
(as in, if I9 = $65.20, the formula gives me $29.34, where as I would
prefer
$29.00)

Ooops. Hit the Send key too soon.

=ROUND(I9*.45,0)


On Sun, 13 Mar 2005 23:21:16 -0600, Myrna Larson
wrote:

Changing the format does not change the underlying data. If it was 4.758
before, it may display as 4.76, but the value is still 4.758.

To get an even number of dollars, rounded down, it's =INT(I9*.45), or do do
true rounding, =ROUND(I9*.45)


On Sun, 13 Mar 2005 19:55:03 -0800, Dismal
wrote:

try formatting the cell you want to currency with zero decimal places.

"nicklissa" wrote:

new to this, the answer is probably right in front of me and I don't know
it!

I use a speadsheet to calculate several types of daily information. There
are several cells for each day, each with it's own calculations. Towards
the
end of the range of cells, I would like one of the final numbers to be
rounded, so that all functions after this work off of the rounded number.
Is
there a way to do this without adding an extra column for the rounding
function?

Formula looks like this: =I9*.45

It always gives me a dollar amount with odd cents, and I'd rather have an
even number. How do I make the round function part of this formula.
(as in, if I9 = $65.20, the formula gives me $29.34, where as I would
prefer
$29.00)