One way:

=TEXT(B21-C21,"$0.00_) ;($0.00) ") & IF(B21C21,"Under","Over") & "
Budget"

Another:

=B21-C21

Format with Format/Cells/Number/Custom

$0.00_) "Under Budget";($0.00) "Over Budget";0.00_) "On Budget"

In article ,
"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.