# Format Result from a Formula

#### esgca2010

##### New Member
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%)

It is truly appreciated.

Respectfully,

Elaine

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### mrshl9898

##### Well-known Member
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,"%)"))

Last edited:

#### esgca2010

##### New Member
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

Replies
9
Views
75
Replies
2
Views
36
Replies
2
Views
41
Replies
10
Views
89
Replies
6
Views
65