diverting output

  • Thread starter Thread starter -az
  • Start date Start date
A

-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
 
Formulas in worksheets can't change the values in other cells. They only return
values to the cell holding the formula.
 
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
 
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.
 
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
 
Back
Top