diverting output

[-az]

hello,

how do i make a function in one cell alter the value of another cell?

i would like to do the following:
if cell1 equals "test string" then make cell(3 + value of cell2)
increment by 1

the reason why i can't put the function in the output cell is because
the range of output cells is the same target for a whole bunch of these

functions.

-az

[Flintstone]

Maybe something like this.

=IF(A1="test string",(A3+A2)+1,"")

Matt

[Dave Peterson]

Formulas in worksheets can't change the values in other cells. They only return
values to the cell holding the formula.

-az wrote:
>
> hello,
>
> how do i make a function in one cell alter the value of another cell?
>
> i would like to do the following:
> if cell1 equals "test string" then make cell(3 + value of cell2)
> increment by 1
>
> the reason why i can't put the function in the output cell is because
> the range of output cells is the same target for a whole bunch of these
>
> functions.
>
> -az

--

Dave Peterson

[-az]

are you sure? that sounds a bit limiting. i have a .xls file at work
that sends an email for me, so i would've thought that changing the
value of another cell would be simple.
-az

[Dave Peterson]

You sure it's a formula that's changing that other cell?

If you have one that does that, please post it.

If the other cell gets changed, it could be a macro that's doing the work for
you.

-az wrote:
>
> are you sure? that sounds a bit limiting. i have a .xls file at work
> that sends an email for me, so i would've thought that changing the
> value of another cell would be simple.
> -az

--

Dave Peterson

[-az]

i'm not too sure if it changes other cells or not, but i'm saying that
it does something pretty complex, and changing another cell seems
pretty rudimentary in comparison.

maybe i'll just try to use a macro or something. where's a good place
to start learning about macros?

-az

[Dave Peterson]

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

-az wrote:
>
> i'm not too sure if it changes other cells or not, but i'm saying that
> it does something pretty complex, and changing another cell seems
> pretty rudimentary in comparison.
>
> maybe i'll just try to use a macro or something. where's a good place
> to start learning about macros?
>
> -az

--

Dave Peterson