if statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
You need to put this formula in all of those cells

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


--


Regards,


Peo Sjoblom
 
Any other conditions?

Try this in I29:

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

then copy it to the other cells.

Hope this helps.

Pete
 
Hi Karen,

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

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

Hope this helps,

Gav.
 
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?
 
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?
 
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?
 
If??? I understand

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

if range("i31")="x" then
range("b7")="z"
range("g8")="q"
end if
 
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...
 
Back
Top