View Single Post
  #6   Report Post  
Dave Peterson
 
Posts: n/a
Default

=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