diverting output

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

-az - 24 Feb 2006 00:04 GMT

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

Reply to this Message

Dave Peterson - 24 Feb 2006 00:27 GMT

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

> hello,
>
[quoted text clipped - 10 lines]
>
> -az

Signature

Dave Peterson

Reply to this Message

-az - 24 Feb 2006 00:38 GMT

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

Reply to this Message

Dave Peterson - 24 Feb 2006 00:56 GMT

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.

> 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

Signature

Dave Peterson

Reply to this Message

-az - 24 Feb 2006 02:48 GMT

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

Reply to this Message

Dave Peterson - 24 Feb 2006 03:02 GMT

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

> 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
[quoted text clipped - 4 lines]
>
> -az

Signature

Dave Peterson

Reply to this Message

Flintstone - 24 Feb 2006 00:29 GMT

Maybe something like this.

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

Matt

Signature

Flintstone

Reply to this Message