View Single Post
  #2   Report Post  
gls858
 
Posts: n/a
Default

Shadyhosta wrote:
I want to use a formula so that when a value over zero is put into one cell,
a line of text prints in another cell. I know it is an if then function, but
I've forgotten the exact formula and the way to encode the text message in
the formula.

Try this:

=IF(A10,"print this text","print this other text")

gls858