Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
=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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|