| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How do I make lines appear after entering a number in a cell? | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
