brainteaser?

[nicklissa]

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)

 

[Dismal]

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

 

[Ron Rosenfeld]

=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

 

[Myrna Larson]

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)

 

[Myrna Larson]

Ooops. Hit the Send key too soon.

=ROUND(I9*.45,0)