View Single Post
  #3   Report Post  
Kevin H. Stecyk
 
Posts: n/a
Default

Spoony_13wrote...

I am using an IF function and I want my TRUE value to say "YOU OWE X" with
the "X" being the numerical value cell F50. The way I am setting it up,
it
keeps reading "YOU OWE F50." How can I get the cell to read the number in
F50 instead of just F50?


Hi,

Try,

="You owe " & TEXT(F50,"$0.00")

That is one way.

Best regards,
Kevin