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