![]() |
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 |
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 |
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