diverting output
 

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

diverting output
 

You have a reply to your post in .excel.

-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