How do you calculate the last item of Double 11? The following Xiaobian for everyone to share the method
Tools/Materials
1
DELLG3
2
Windows 10 Home Chinese Version
3
Microsoft Office Excel 2016
Methods/Steps
1
First of all, open the "Double eleven" excel sheet on the computer
2
This information is taken from experience without authorization
3
Then enter the formula: Final payment = total price - deposit - immediate reduction amount, that is, A2-B2-C2
4
Finally, click enter to complete the calculation of the final payment.
Matters needing attention
I hope the method of Xiaobian will be helpful to you