ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   some one help me please (https://www.excelbanter.com/new-users-excel/54179-some-one-help-me-please.html)

inneedjen

some one help me please
 
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

Roger Govier

some one help me please
 
Hi

In cell F2 enter =D2
Copy down as appropriate.
Regards

Roger Govier


inneedjen wrote:
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


ufo_pilot

some one help me please
 
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



"inneedjen" wrote:

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



All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com