| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I make a whole number
I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer
to be 263.81. I know I can format the cell to only show 2 decimal places, but that is not what I need. I would like on only have the number 263.81 so if I need to use that number to calculate some where else, it will not use the rounded number of 263.8125, but the whole number of 263.81 Does that make since |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I make a whole number
Hi
Use this formula: =ROUND(23.45*11.25,2) to round the result to 2 decimal places. Hope this helps. Andy. "sbhayes" wrote in message ... I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer to be 263.81. I know I can format the cell to only show 2 decimal places, but that is not what I need. I would like on only have the number 263.81 so if I need to use that number to calculate some where else, it will not use the rounded number of 263.8125, but the whole number of 263.81 Does that make since |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I make a whole number
=ROUND(A1,2)
"sbhayes" wrote: I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer to be 263.81. I know I can format the cell to only show 2 decimal places, but that is not what I need. I would like on only have the number 263.81 so if I need to use that number to calculate some where else, it will not use the rounded number of 263.8125, but the whole number of 263.81 Does that make since |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I make a whole number
Thank you the Round worked GREAT!!!!!
"Toppers" wrote: =ROUND(A1,2) "sbhayes" wrote: I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer to be 263.81. I know I can format the cell to only show 2 decimal places, but that is not what I need. I would like on only have the number 263.81 so if I need to use that number to calculate some where else, it will not use the rounded number of 263.8125, but the whole number of 263.81 Does that make since |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I make a whole number
Try something like this:
=ROUND(23.45*11.25,2) Does that help? *********** Regards, Ron XL2002, WinXP "sbhayes" wrote: I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer to be 263.81. I know I can format the cell to only show 2 decimal places, but that is not what I need. I would like on only have the number 263.81 so if I need to use that number to calculate some where else, it will not use the rounded number of 263.8125, but the whole number of 263.81 Does that make since |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I make a whole number
=ROUND(A1,2)
Please post to one group only. "sbhayes" wrote: I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer to be 263.81. I know I can format the cell to only show 2 decimal places, but that is not what I need. I would like on only have the number 263.81 so if I need to use that number to calculate some where else, it will not use the rounded number of 263.8125, but the whole number of 263.81 Does that make since |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I make a whole number
My apologies ... I was flicking between groups so thought you had postd to
another NG "Toppers" wrote: =ROUND(A1,2) Please post to one group only. "sbhayes" wrote: I am calculating 2 numbers say 23.45*11.25=263.8125 I would like the answer to be 263.81. I know I can format the cell to only show 2 decimal places, but that is not what I need. I would like on only have the number 263.81 so if I need to use that number to calculate some where else, it will not use the rounded number of 263.8125, but the whole number of 263.81 Does that make since |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| make cell entries a negative number | New Users to Excel | |||
| make negative number value to zero | Excel Worksheet Functions | |||
| make negative number value to zero | Excel Worksheet Functions | |||
| How can I make autofilter show the filtered number of rows | Excel Worksheet Functions | |||
Hybrid Mode
