Formula and Print help

[alanb]

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

 

[maxflia10]

=IF(A1>=101,"john",IF(A1<=99,"peter"))

 

[alanb]

Sorry I did not explain properly
If any value under 100 is entered I want it
to say Pete and any value over 100 to say John
Thanks again
Alan

 

[maxflia10]

This does what you asked for, but if 100 is entered, it's blank

=if(a1<100,"Pete",if(a1>100,"John",""))

 

[alanb]

Thankyou so much
I should have tries it before I posted again
I can't belive the speed in your replies
Cheers
Alanb

 

[maxflia10]

And I'm not sure about the printing part, but entering Ctrl + ~ shows the formulas on the page