D
Dab
I know that there's a way to make a cell a particular value based on the
entries of a range, or array of cells, but is it possible to do the reverse,
using only one formula in a cell.
Here's what I'm trying to do:
What I would like to do is set one of a range of cell to have a value based
on the value in A2.
Example: Cell A1 has a value of 2, A2 has a value of 2007. I want A10 to
equal A1, i.e.:2
Cell A1 has a value of 2, A2 has a value of 2008. I want
A11 to equal A1, i.e.:2
Cell A1 has a value of 2, A2 has a value of 2009. I want
A12 to equal A1, i.e.:2
I know that this can be done by filling a range of cells with the proper
formulas, but what I'm looking for is a formula that will set the value of a
third cell, based on the value of some other cell. Something like
If I try: =IF(E9=0,"",E15=E9), but his simply returns a value of "False", It
doesn't set the value of E15 to the value of E9 which is what I want.
Let me know if you have any suggestions. Thanks.
entries of a range, or array of cells, but is it possible to do the reverse,
using only one formula in a cell.
Here's what I'm trying to do:
What I would like to do is set one of a range of cell to have a value based
on the value in A2.
Example: Cell A1 has a value of 2, A2 has a value of 2007. I want A10 to
equal A1, i.e.:2
Cell A1 has a value of 2, A2 has a value of 2008. I want
A11 to equal A1, i.e.:2
Cell A1 has a value of 2, A2 has a value of 2009. I want
A12 to equal A1, i.e.:2
I know that this can be done by filling a range of cells with the proper
formulas, but what I'm looking for is a formula that will set the value of a
third cell, based on the value of some other cell. Something like
If I try: =IF(E9=0,"",E15=E9), but his simply returns a value of "False", It
doesn't set the value of E15 to the value of E9 which is what I want.
Let me know if you have any suggestions. Thanks.