Hi
Can any one help please, It may be simple, but I'm stuck.
1.I want my cell to change words if another cell is lesser or greater than a set value of say 100
Example cell A1 is 101 I want cell B1 to show John if A1 is 99 I want it to show Pete
2.How can I print a page showing all my formulas in the cells
Thanks very very much in Advance
Can any one help please, It may be simple, but I'm stuck.
1.I want my cell to change words if another cell is lesser or greater than a set value of say 100
Example cell A1 is 101 I want cell B1 to show John if A1 is 99 I want it to show Pete
2.How can I print a page showing all my formulas in the cells
Thanks very very much in Advance