If/then to print text.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Shadyhosta said:
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.
Click to expand...
Try this:

=IF(A1>0,"print this text","print this other text")

gls858
 
The value is in A2
In the other cell enter

=IF(A2>0,"this is greater than zero or what ever","")

Regards
Bill K
 
Back
Top