change cell selection and IF with multiple resutls
 

Hi all,

Is it possible in excel to do teh following

1- move the selection to a new location based on a certain criteria? for
example, IF(A1=C4 Then move the cell selection to D4)

2- make an IF statement with multiple results...for example, =IF(A1=A3, 100
AND D8=200....etc)...the idea is to make an IF statemetn such that, IF A1=A3,
Then the current cell should be 100 and the cell next to it should be 200,
and the cell next to that one should be 300...and so on...

Thank you

change cell selection and IF with multiple resutls
 

A formula can only change the value of the cell that it is in, it
can't change the value of another cell. So for your first question,
you would need to put a formula in cell D4, something like:

=IF(A1=C4,cell,"")

where cell needs to be your reference to the "selected" cell.

For your second question, again a formula cannot change another cell's
contents. However, you could put:

=IF(A1=A3,100,"")

in what you call the "current" cell (assume this is D4), and in the
cell next to it (D5 or E4 ??) you could put this:

=IF(D4="","",D4+100)

That cell could be copied down or across to increase the other cells
by 100 each time.

Hope this helps.

Pete

On Sep 8, 6:45*am, Dream wrote:
Hi all,

Is it possible in excel to do teh following

1- move the selection to a new location based on a certain criteria? for
example, IF(A1=C4 Then move the cell selection to D4)

2- make an IF statement with multiple results...for example, *=IF(A1=A3, 100
AND D8=200....etc)...the idea is to make an IF statemetn such that, IF A1=A3,
Then the current cell should be 100 and the cell next to it should be 200,
and the cell next to that one should be 300...and so on...

Thank you

change cell selection and IF with multiple resutls
 

Thanks Pete, for your response. This is very useful.

"Pete_UK" wrote:

A formula can only change the value of the cell that it is in, it
can't change the value of another cell. So for your first question,
you would need to put a formula in cell D4, something like:

=IF(A1=C4,cell,"")

where cell needs to be your reference to the "selected" cell.

For your second question, again a formula cannot change another cell's
contents. However, you could put:

=IF(A1=A3,100,"")

in what you call the "current" cell (assume this is D4), and in the
cell next to it (D5 or E4 ??) you could put this:

=IF(D4="","",D4+100)

That cell could be copied down or across to increase the other cells
by 100 each time.

Hope this helps.

Pete

On Sep 8, 6:45 am, Dream wrote:
Hi all,

Is it possible in excel to do teh following

1- move the selection to a new location based on a certain criteria? for
example, IF(A1=C4 Then move the cell selection to D4)

2- make an IF statement with multiple results...for example, =IF(A1=A3, 100
AND D8=200....etc)...the idea is to make an IF statemetn such that, IF A1=A3,
Then the current cell should be 100 and the cell next to it should be 200,
and the cell next to that one should be 300...and so on...

Thank you

change cell selection and IF with multiple resutls
 

You're welcome - thanks for feeding back.

Pete

On Sep 8, 1:24*pm, Dream wrote:
Thanks Pete, for your response. This is very useful.



"Pete_UK" wrote:
A formula can only change the value of the cell that it is in, it
can't change the value of another cell. So for your first question,
you would need to put a formula in cell D4, something like:

=IF(A1=C4,cell,"")

where cell needs to be your reference to the "selected" cell.

For your second question, again a formula cannot change another cell's
contents. However, you could put:

=IF(A1=A3,100,"")

in what you call the "current" cell (assume this is D4), and in the
cell next to it (D5 or E4 ??) you could put this:

=IF(D4="","",D4+100)

That cell could be copied down or across to increase the other cells
by 100 each time.

Hope this helps.

Pete

On Sep 8, 6:45 am, Dream wrote:
Hi all,

Is it possible in excel to do teh following

1- move the selection to a new location based on a certain criteria? for
example, IF(A1=C4 Then move the cell selection to D4)

2- make an IF statement with multiple results...for example, *=IF(A1=A3, 100
AND D8=200....etc)...the idea is to make an IF statemetn such that, IF A1=A3,
Then the current cell should be 100 and the cell next to it should be 200,
and the cell next to that one should be 300...and so on...

Thank you- Hide quoted text -

- Show quoted text -