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.
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 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(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
"Shadyhosta" <[email protected]> wrote in message
news:[email protected]...
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks