Incomplete Calcuation

  • Thread starter Thread starter Jamie
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel 2003 1
The If function 4
Hide blank data 4
how to create a formula with expiry condition 2
if formula for time sheet. - help 1
Worksheet Calculations not working 4
Cell to the left of an Index function result 2
directing cell contents dependent on its value 2

Back
Top