rounding the results of a formula

[mprokop]

basic formula

=SUM(C42*E42)

how do I round the answer ? i.e. $242.62 to show $243.00 in the cell

 

[Frank Kabel]

Hi
try
=ROUND(C42*E42,0)

note: The SUM function is not required

 

[JE McGimpsey]

one way:

=ROUND(C42*E42,0)

another:

=INT(C42*E42)


Note that SUM() isn't necessary. C42*E42 returns the product - all SUM()
does is SUM a single cell, i.e., returns its input.

 

[Bob Umlas Excel MVP]

First, you don't need the SUM function. Next, use:
=ROUND(C42*E42,0)

 

[engmgriff]

Hi

Put your formula into a cell, then right click that cell go to format
cell, then number, scroll to custom and in the 'type' part at the top
input $0 this will round up the number.

Matt

 

[Ron Rosenfeld]

Hi

Put your formula into a cell, then right click that cell go to format
cell, then number, scroll to custom and in the 'type' part at the top
input $0 this will round up the number.

Be aware that your procedure only rounds the display. And it does arithmetic
rounding, not a "round up" as you stated. The contents of the cell remains
unchanged (unrounded) which would become apparent if the cell was used in
another formula.


--ron