if statement

[Guest]

I'm need to create a formula so if I place an X in Cell I27, X's will be
placed in cells I29, I31, D27, D29, D31. Can anyone help?

 

[Guest]

In cells I29, I31, D27, D29, D31 enter:

=IF(I27="X","X","")

 

[Guest]

Maybe this in I29, I31 etc

=IF(I27="X",I27,"")

Mike

 

[Don Guillett]

How about a nice macro
range("i27,i29,i31,d27,d29,d31")="x"

 

[Peo Sjoblom]

You need to put this formula in all of those cells

=IF($I$27="X","X","")


--


Regards,


Peo Sjoblom

 

[Pete_UK]

Any other conditions?

Try this in I29:

=IF($I$27="X","X","")

then copy it to the other cells.

Hope this helps.

Pete

 

[Guest]

Hi Karen,

You could try this in cells I29, I31, D27, D29, D31

=IF($I$27="X","X","")

Hope this helps,

Gav.

 

[Guest]

Thanks all, that worked. I have another question for you. I asked it
yesterday, but no one responded to the question. Here it is.

I have protected my workbook so users can only modify certain cells. I have
a Button to clear all cells, but when I protect the workbook, the button is
protected too. How do I unprotect this button?

 

[Guest]

Thank you Don, you saved my bacon, but tell me something, i used this macro
but i wanted it to do something even better, i have a drop down menu of 6
Animal Names on a datasheet i then make say cell I27 = the active Animal name
as it is selected via dropdown (A1) called Cat, say. but i want the macro to
work regardless of the name selection. Names could be Dog, Rat, Cow etc
How do i do that?

 

[Guest]

Good morning Don, what is i wanted the "x" that is now populated in i31 to
further populate b7 with "z" and g8 with "q"? how do i write this?

 

[Don Guillett]

If??? I understand

range("i27,i29,i31,d27,d29,d31")="x"

if range("i31")="x" then
range("b7")="z"
range("g8")="q"
end if

 

[Guest]

Don, yes you did understand and yes that is exactly what i wanted ...i have
now posted another question i dont know if you coud help further.
I want to attach a parent to several child and by selecting the parent in A1
b2,b3,b4 would be populated and if i want i could select the child and the
grandchildren would appear too...
If its tyoo much thanks anyway for the previous solution...