View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Formula Question

sory my mistake on the formulae

use =if(d30,f2+d3,f2-e3)

hth
regards from Brazil
Marcelo

"Marcelo" escreveu:

Hi Dramajuana,

on F column use:

=(if(or(d3=0,d3="")),f2+d3,f2-c3)

hth
regards from Brazil
Marcelo

"dramajuana" escreveu:

Okay, I don't really know how to word this, so I'm sorry if it sounds awkward.

I'm trying to set up Excel so that it can basically be my checkbook registry
so that I don't mess up the math. So, I have a column for debits (D), one for
credits (E) and one for the running balance (F).

Is there a forumla that I can apply to column F that will see what's in D
and E for that row, add or subtract what's there, and then apply that to the
previous row's F? Or do I just have to do separate forumlas for each row...?