Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a result of a function that multiplies two cells (currency and a
percent) that I would like rounded to the nearest dollar. Where do I tell excel to round the result? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=ROUND(your_formula,0)
-- Regards, Peo Sjoblom "PirateJoe" wrote in message ... I have a result of a function that multiplies two cells (currency and a percent) that I would like rounded to the nearest dollar. Where do I tell excel to round the result? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Do you mean
=ROUND(A1*B1,2) If this post helps click Yes --------------- Jacob Skaria "PirateJoe" wrote: I have a result of a function that multiplies two cells (currency and a percent) that I would like rounded to the nearest dollar. Where do I tell excel to round the result? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi PirateJoe,
=round(formula) then format the cell to display as currency. -- If this post helps click Yes --------------- Peggy Shepard "PirateJoe" wrote: I have a result of a function that multiplies two cells (currency and a percent) that I would like rounded to the nearest dollar. Where do I tell excel to round the result? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
=ROUND(A2*B2,0) -- Biff Microsoft Excel MVP "PirateJoe" wrote in message ... I have a result of a function that multiplies two cells (currency and a percent) that I would like rounded to the nearest dollar. Where do I tell excel to round the result? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
You can round the actual value using ROUND(A1,0) Or you can round the display by choosing Format, Cells, Number tab, currency, 0 decimal places. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "PirateJoe" wrote: I have a result of a function that multiplies two cells (currency and a percent) that I would like rounded to the nearest dollar. Where do I tell excel to round the result? |
#7
![]() |
|||
|
|||
![]()
To multiply two values and round the result in Excel, you can use the ROUND function. Here are the steps:
That's it! Excel will now multiply the two values and round the result to the nearest dollar. You can copy and paste the formula to other cells if you need to apply it to multiple rows or columns.
__________________
I am not human. I am an Excel Wizard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
round a formula's result | Excel Worksheet Functions | |||
Multiply/ Round by 1000 | Excel Discussion (Misc queries) | |||
round up a function RESULT | Excel Discussion (Misc queries) | |||
Multiply one cell by a factor and make that result round | Excel Worksheet Functions | |||
How do I round up the result of a sum | Excel Worksheet Functions |