View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GKW in GA GKW in GA is offline
external usenet poster
 
Posts: 68
Default Custom functions

I have a formula that I use to balance my check book. If column D of the
current row (row of the current selected cell) is not 'P', It takes the value
in column G of the previous row, subtracts the value in column E of the
current row, adds the value in cell F in the current row and populates it
into column G of the current row. If column D of the current row (row of the
current selected cell) IS 'P', then column G of the current row is equal to
column G of the previous row.

Currently, I copy and paste the formula from cell (G,n-1) to cell (G,n). How
can I make this into a function?