Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If/then to print text.
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
The value is in A2 In the other cell enter =IF(A20,"this is greater than zero or what ever","") Regards Bill K "Shadyhosta" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print all the text in a cell | Excel Discussion (Misc queries) | |||
Set "print all text as black" as default in Excel | Excel Worksheet Functions | |||
Text print size | Excel Discussion (Misc queries) | |||
Can I place visible text in cell that won't print | Excel Discussion (Misc queries) | |||
Text in Blue colour, but print in black colour | Excel Worksheet Functions |