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-A20,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