words and numbers in an IF function
 

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

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

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?

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?

=if(a1="something","You owe "&F50,"")
or maybe
=if(a1="something","You owe "&text(F50,$0.00"),"")

Same kind of thing for time/date:

"Pay by: " & text(now(),"mm/dd/yyyy hh:mm:ss")



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?

--

Dave Peterson

On Thu, 16 Dec 2004 18:47:01 -0800, 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?

If(logical_test, "YOU OWE " & F50, value_if_false)


--ron

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?