You are correct. So to overcome that, Put your currency symbol into the
formula too.

=IF((B21-C21)0,"$"&B21-C21 & " Under Budget", "$"&B21-C21 & " Over Budget")

"M.Siler" wrote:

I have the following:

=IF((B21-C21)0,B21-C21 & " Under Budget", B21-C21 & " Over Budget")

How can I get the resulting value to be formatted as currency? I have
formatted the cell as currency but I guess with the & "text" it doesn't
treat the numerical part as currency.