|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
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?
|