M
mprokop
basic formula
=SUM(C42*E42)
how do I round the answer ? i.e. $242.62 to show $243.00 in the cell
=SUM(C42*E42)
how do I round the answer ? i.e. $242.62 to show $243.00 in the cell
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
try
=ROUND(C42*E42,0)
note: The SUM function is not required
try
=ROUND(C42*E42,0)
note: The SUM function is not required
J
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.
=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.
B
Bob Umlas Excel MVP
First, you don't need the SUM function. Next, use:
=ROUND(C42*E42,0)
=ROUND(C42*E42,0)
E
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
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
R
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