IF formula with correct formatting in result

[Guest]

This may be simple for someone
Cell A1 = $3,500
Cell A2 = $2,000
example formula
=IF(A1="","",IF(A1=A2,"ok - matched",IF(A1-A2>0,A1-A2&" overstated","A2-A1&"
understated")))
This if statement provides the answer --> 1500 overstated
But I want the answer to be --> $1,500 overstated
Is there a way I can build the formatting of the dollar amount into the IF
statement, or is there a way I can enter a custom format that allows for the
varying text depending on the sum result.

thanks for your help

 

[Guest]

You could use the text function
TEXT(A1-A2,"$#,##0)&" overstated"

 

[Guest]

Left out a quote
TEXT(A1-A2,"$#,##0")&" overstated"

 

[Guest]

Thanks, I'l go and try that now

Left out a quote
TEXT(A1-A2,"$#,##0")&" overstated"