View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
-az
 
Posts: n/a
Default 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