if statement
 

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?

if statement
 

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

=IF(I27="X","X","")
--
Gary''s Student - gsnu200752


"Karen Smith" wrote:

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?

if statement
 

Maybe this in I29, I31 etc

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

Mike

"Karen Smith" wrote:

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?

if statement
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Karen Smith" wrote in message
...
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?

if statement
 

You need to put this formula in all of those cells

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


--


Regards,


Peo Sjoblom


"Karen Smith" wrote in message
...
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?

if statement
 

Any other conditions?

Try this in I29:

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

then copy it to the other cells.

Hope this helps.

Pete

On Oct 30, 1:43 pm, Karen Smith
wrote:
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?

if statement
 

Hi Karen,

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

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

Hope this helps,

Gav.

"Karen Smith" wrote:

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?

if statement
 

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?


"Gav123" wrote:

Hi Karen,

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

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

Hope this helps,

Gav.

"Karen Smith" wrote:

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?

if statement
 

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?

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Karen Smith" wrote in message
...
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?

if statement
 

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Karen Smith" wrote in message
...
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?

if statement
 

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 Guillett
Microsoft MVP Excel
SalesAid Software

"whatzzup" wrote in message
...
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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Karen Smith" wrote in message
...
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?

if statement
 

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

"Don Guillett" wrote:

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 Guillett
Microsoft MVP Excel
SalesAid Software

"whatzzup" wrote in message
...
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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Karen Smith" wrote in message
...
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?