if function

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
In A1: 1
In B1: =A1





- Show quoted text -
Click to expand...

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.
 
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
 
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Typed text appears in wrong cell 0
Linking two cells of text together 3
Formula Help 0
Excel VBA 1
Set non-continuous PrintArea via Function / Name 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Date Help 1
add two cells from seperate work sheets into a cell on seperate wo 6

Back
Top