Format 200000 as currency within concatenate statement

[Steve Stadelhofer]

I would like to format the number in this function within
the concatenate statement as currency. i.e., $200,000.00
e.g.,
=CONCATENATE("(accrual balance = ",ROUND(D11,2))
where d11 is 200,000.00
or,
=CONCATENATE("accrual balance = ",200000)
to be accrual balance = $200,000.00

Thanks,
Steve

 

[Guest]

=IF(A1=200000,TEXT(A1,"$#,#.00"),"")

 

[Fred Smith]

Instead of ROUND(D11,2), use TEXT(D11,"$#,##0.00")