if function
 

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?

if function
 

In A1: 1
In B1: =A1

"new to excel" wrote:

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?

if function
 

On Nov 17, 9:44 am, Teethless mama
wrote:
In A1: 1
In B1: =A1



"new to excel" wrote:
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?- Hide quoted text -

- 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.

if function
 

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
wrote:

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?

if function
 

thanks very much

"Gord Dibben" wrote:

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
wrote:

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?