rounding to the nearest Dollar

[H]

Does anyone know how to set your formula to round to the nearest Dollar

=CONCATENATE(B18*B19*B20)&" - "&B5

 

[Shane Devenshire]

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)

 

[JoeU2004]

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 -----