View Single Post
  #1   Report Post  
M.Siler
 
Posts: n/a
Default Formatting Question

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.