Formatting Question

[M.Siler]

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.

[bigwheel]

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.
>
>
>

[bigwheel]

Or, you could do it this way:-

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

[JE McGimpsey]

One way:

=TEXT(B21-C21,"$0.00_) ;($0.00) ") & IF(B21>C21,"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 <O23scU9iFHA.3568@tk2msftngp13.phx.gbl>,
"M.Siler" <John.Doe@NoSpam.com> 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.