Formula and Print help

alanb

New Member
Joined
Nov 13, 2002
Messages
7
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
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

alanb

New Member
Joined
Nov 13, 2002
Messages
7
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

Well-known Member
Joined
May 20, 2002
Messages
890
This does what you asked for, but if 100 is entered, it's blank

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

alanb

New Member
Joined
Nov 13, 2002
Messages
7
Thankyou so much
I should have tries it before I posted again
I can't belive the speed in your replies
Cheers
Alanb
 

maxflia10

Well-known Member
Joined
May 20, 2002
Messages
890
And I'm not sure about the printing part, but entering Ctrl + ~ shows the formulas on the page
 

Watch MrExcel Video

Forum statistics

Threads
1,123,493
Messages
5,601,998
Members
414,490
Latest member
Rip181

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top