Incomplete Calcuation

J

Jamie

This may be a common question...
I have a sheet that has the following column headings; Debit, Credit, and
Balance. These are tracked monthly so my row headings are Jan., Feb., etc. I
have the balance formula pasted down through all the months although I do
not yet have the data for Sept. - Dec. The formula is still calculating and
giving me an incorrect number. How do I keep the formula there without
having it calculate until I enter the data?
 
D

Don

Hi Jamie,

Start your cells with an "IF(AND....." query....something
like this...assuming B1 = Debit..C1 = Credit..D1 =
Balance...put this in D1 and drag it down...

=IF(AND(B1="",C1=""),"",....the rest of your equation
here...)

HTH,

Don
 
Top