Format Result from a Formula

[esgca2010]

Hello,

I would like to format a result with currency, no dollar sign, and zero decimals. Cell H2 is the cell in question.

Formula:
=CONCAT(H2," (",ROUND(I2,2)*100,"%)")

Result:
222000 (40%)

Preferred Result:
222,000 (40%)

An advanced thank you for your time and support.

It is truly appreciated.

Respectfully,

Elaine

 

[mrshl9898]

How's this?

=IF(H2<1000,H2&" ("&ROUND(I2,2)*100&"%)",TEXT(H2,"0,000")&" ("&ROUND(I2,2)*100&"%)")

CONCAT wasn't working for me, though CONCATENATE was.

=IF(H2<1000,CONCATENATE(H2," (",ROUND(I2,2)*100,"%)"),CONCATENATE(TEXT(H2,"0,000")," ("&ROUND(I2,2)*100,"%)"))

 

[esgca2010]

AWESOME! Thank you! It would have me a very long time to do this IF statement.

Again, thank you for your quick response to my question! You are the BEST!!!

Elaine