After entering formula how do you make the number roundup
 

eg. =C3+D5-J5

then I want the answer which will be a changing number to round up to two
decimal places from the four that will result

4.5671 to 4.58

After entering formula how do you make the number roundup
 

right click on the cell where you have the formula, click Format
Cells..., then on Number tab click Number from Category list, on right
side change Decimal places to 2 and press Ok.


Sam Wrote:
eg. =C3+D5-J5

then I want the answer which will be a changing number to round up to
two
decimal places from the four that will result

4.5671 to 4.58


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=570994

After entering formula how do you make the number roundup
 

Or just revise the formula to:

=Round(C3+D5-J5,2)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"starguy" wrote in
message ...

right click on the cell where you have the formula, click Format
Cells..., then on Number tab click Number from Category list, on right
side change Decimal places to 2 and press Ok.


Sam Wrote:
eg. =C3+D5-J5

then I want the answer which will be a changing number to round up to
two
decimal places from the four that will result

4.5671 to 4.58


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=570994