I have the following values 774, 918, 1495 - I am trying to display them with text and multiplication:
=CONCATENATE("14K: $",AJ3*1.9, " 18K: $",AJ67*1.9," PLAT: $",AJ93*1.9)
The following is displayed: 14K: $1470.6 18K: $1744.2 PLAT: $2840.5
I want to have the numbers to be rounded off, in other words, no decimals.
How can I round them?
Thank you
Bookmarks