Hi Spoony
=IF(test_bit,"You owe " & F50,false_bit)
or
=IF(test_bit, "You owe " & TEXT(F50,"$#,###.00"),false_bit)
Cheers
JulieD
"Spoony_13" wrote in message
...
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?
|