some one help me please

G

Guest

Can someone help me i need to get the total from the amount column to
generate over to the amont paid column, the to columns always are the same
amount. this is how my spreadsheet looks.
Loan # Invoice # Invoice Date Amount Date Paid Amount Paid
please help
 
G

Guest

two ways I would do that
1.) click in the cell that you want the final result then = (equal sign)
then click on the cell you want it to read.

2.) =IF(D9<>"",D9,"") this will return blanks when there is no data (
instead of zero's)
it will also "read" text in the cell, not just numbers
 

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

Top