Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
rounding to the nearest Dollar
Does anyone know how to set your formula to round to the nearest Dollar
=CONCATENATE(B18*B19*B20)&" - "&B5 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
rounding to the nearest Dollar
Hi,
What does the formula you showed us have to do with your question? What is in B18:B20 and B5? This function returns a text argument something like 6 - 12 In general you format a cell to the nearest dollar by setting the decimal places to 0. If you want to round to 0 decimal places you generally use =ROUND(A1,0) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "H" wrote: Does anyone know how to set your formula to round to the nearest Dollar =CONCATENATE(B18*B19*B20)&" - "&B5 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
rounding to the nearest Dollar
"H" wrote:
Does anyone know how to set your formula to round to the nearest Dollar =CONCATENATE(B18*B19*B20)&" - "&B5 Whose formula is this (who is "your"), and what part of it is intended to be a dollar amount? This demonstrates why it is a bad idea to put follow-up questions into a new thread instead of the original thread. We lose the context, which is often needed in order to understand the follow-up question. I confess: I don't know why anyone would write CONCATENATE(B18*B19*B20). Assuming they (you) mean B18*B19*B20 computes a currency value (e.g. dollars and cents), perhaps the following does what you want, rounding to the dollar: =ROUND(B18*B19*B20,0) & " - " & B5 PS: You could write CONCATENATE(ROUND(B18*B19*B20,0), " - ", B5). But I see no value in using the CONCATENATE function instead of the concatenate operator "&". ----- original message ----- "H" wrote in message ... Does anyone know how to set your formula to round to the nearest Dollar =CONCATENATE(B18*B19*B20)&" - "&B5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rounding numbers to the nearest dollar amount | Excel Worksheet Functions | |||
How do I round up to the nearest Dollar in Excel?? | Excel Discussion (Misc queries) | |||
Rounding up to the nearest dollar | Excel Worksheet Functions | |||
What is the formula for rounding a dollar amount to the nearest ni | New Users to Excel | |||
rounding to nearest hundred dollar in Excel | New Users to Excel |