G
Guest
How do you link two cells together and if 1 is typed into a cell I want off
typed into another cell?
Can this be done?
typed into another cell?
Can this be done?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
In A1: 1
In B1: =A1
In B1: =A1
B
BIG D
In A1: 1
In B1: =A1
- Show quoted text -
If you want the word "off" to appear in the second cell based on the
number 1 bein entered into the first cell try this.
In the cell where "off" will appear enter this formula
=if(A1=1,"off","") be sure to adjust cell referance to reflect the
cell number of the frist cell.
G
Gord Dibben
A1 contains 1
B1 contains =IF(A1=1,"off","not off")
Just a guess because your description is a little unclear to me.
Gord Dibben MS Excel MVP
On Sat, 17 Nov 2007 07:37:00 -0800, new to excel <new to
B1 contains =IF(A1=1,"off","not off")
Just a guess because your description is a little unclear to me.
Gord Dibben MS Excel MVP
On Sat, 17 Nov 2007 07:37:00 -0800, new to excel <new to
G
Guest
thanks very much
Gord Dibben said:A1 contains 1
B1 contains =IF(A1=1,"off","not off")
Just a guess because your description is a little unclear to me.
Gord Dibben MS Excel MVP
On Sat, 17 Nov 2007 07:37:00 -0800, new to excel <new to