Tools: Thinkpad E43 1, Windows 10, excel20 19.
1, the purpose of the statement is to urge customers to pay. To clarify who this statement is for, write a few polite words, as shown in the figure.
2. After the header is completed, it is necessary to explain the start and end time of the accounting period, indicate when the bill is, or add a number.
3. Then write down the date and payment items, and enter the formula =C5 for all dates, which will be updated automatically, and then set the cell format to display the desired time format.
4. Then enter payment items according to the payment items generated by customers, such as transportation fees and storage fees.
5. The formula =VLOOKUP(C8,' X:\ folder name \ [workbook name] can be used for the amount column. Xls] worksheet name'! $ A $4: $ I $4994,8,0), that is, the amount corresponding to C8 in the report is extracted from this worksheet.
6. If the cell format is not set in advance, the displayed result is a number. If you want to display it as an amount, you can right-click to set the cell format, as shown in the figure.
7, the total amount to be calculated below, in order to appear formal, you can enter formula = "as of"&in cell B 14; Text (C5, "YYY year M month D day")&; "Your company's total payment is:" ",so the date in the formula will be updated automatically, without having to change it manually every time.
8. Then enter "capital (RMB)" and "lowercase:" in B 15 and D 15 respectively, and the formula after lowercase is simple =SUM(E8:E 13).
9. The formula for displaying the total amount in capital is slightly complicated, which is = if (round (e15,2) = 0, "zero rounding", if (E 15.
10. Next, write a few words to ask the other party to pay, and provide remittance account number, contact telephone number, fax number, email address, contact finance and other information.
1 1. Finally, write business greetings: Best wishes: Shang Qi! And write down the person in charge of the company, and the final date can be calculated by formula =C5.