| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| =if statement | Excel Worksheet Functions | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
