how do I format currency inside the expression of Excel cell?

Question

I am trying to figure out how to format the result in an expression in Excel. I wrote

=IF(C30 > B30, "You would save $" & Format(C30-B30, "Currency") & "!", "No savings")

inside the cell but it doesn't work. Simply put, I want the currency formatted inside the expression.

How?

Answer 1

Have you tried the Text function?

=IF(C30 > B30, "You would save " & Text(C30-B30, "$0.00") & "!", "No savings")