Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding and Multiplying
Can I multiply 2 numbers together and have the answer rounded to 0 decimals?
For example: a1 = 4.25 b1 = 5.25 c1 = 22.31 I want c1 to be rounded to 22 (not just formatted to look like 22 but to actually round the number). Thanks, -- Sue |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding and Multiplying
Put this in C1
=ROUND(A1*B1,0) Vaya con Dios, Chuck, CABGx3 "Sue" wrote: Can I multiply 2 numbers together and have the answer rounded to 0 decimals? For example: a1 = 4.25 b1 = 5.25 c1 = 22.31 I want c1 to be rounded to 22 (not just formatted to look like 22 but to actually round the number). Thanks, -- Sue |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding and Multiplying
Thank you.
-- Sue "CLR" wrote: Put this in C1 =ROUND(A1*B1,0) Vaya con Dios, Chuck, CABGx3 "Sue" wrote: Can I multiply 2 numbers together and have the answer rounded to 0 decimals? For example: a1 = 4.25 b1 = 5.25 c1 = 22.31 I want c1 to be rounded to 22 (not just formatted to look like 22 but to actually round the number). Thanks, -- Sue |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding and Multiplying
You're quite welcome.........happy to help.
Vaya con Dios, Chuck, CABGx3 "Sue" wrote: Thank you. -- Sue "CLR" wrote: Put this in C1 =ROUND(A1*B1,0) Vaya con Dios, Chuck, CABGx3 "Sue" wrote: Can I multiply 2 numbers together and have the answer rounded to 0 decimals? For example: a1 = 4.25 b1 = 5.25 c1 = 22.31 I want c1 to be rounded to 22 (not just formatted to look like 22 but to actually round the number). Thanks, -- Sue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas / rounding | Excel Worksheet Functions | |||
Rounding and Multiplying | Excel Discussion (Misc queries) | |||
Rounding off numbers in Excel 2003 | Excel Worksheet Functions | |||
stop rounding | Excel Discussion (Misc queries) |