View Single Post
  #8   Report Post  
tjtjjtjt
 
Posts: n/a
Default

I'll never make a living as a typist. Thanks for the catch.

tj

"JulieD" wrote:

Hi

i think you mean
=IF(logical_test,"You owe "&F50,value_if_false)

(stray ")

Cheers
JulieD


"tjtjjtjt" wrote in message
...
Try:
=IF(logical_test,"You owe "&F50,"value_if_false)

tj

"Spoony_13" wrote:

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?