sumif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that has 6 colums. (A-F

I have a formula adding A + B + E =

The E colum is C X

Sometimes there is no number in C or D

How can I keep the cells blank if there is no number to read?

Also E is the Balance Colum. If I fill the formula down the page, the balance goes all the rows. How can I keep the cells blank until I put something into a row

Thanks
 
Hi Frank,

Thanks for your reply. But I don't think I explained my problem well enough. Here goes again...

I am trying to make a spreadsheet that will keep a running balance.

A = Deposit
B = Charge
C = Other Charge
D = Rate
E = C divided by D
F = Balance

I can make the formula work for one row at a time. I would like to copy the formulas down so that the sheet is automatic. The problem I am having is with the E formula and F formula. If there is no entry in C,D or F, then I get a #DIV/0 error on both colum E and F.

Also on colum F, when I copy this formula down, it shows the balance all the way down the sheet. Is there a way to keep it empty until something has been put in the row?

Can you recomend a book that might help me with Excel formulas?

Thanks, Sharon

----- Frank Kabel wrote: -----

Hi
try the following in column E
=IF(OR(C1="",D1=""),"",C1*D1)
and copy down
 
Back
Top