Please help me on creating function that will select item by priority defined and subtract from total count and continue to next item, till end of the list, and display the result of each item.
Company provides 3 services to the customers, cleaning ($100), Washing ($50) and Gardening ($50) per month. After providing service the customer paid $170. How to set formula (function) to show that customer paid $100 for Cleaning, $50 for Washing and $20 for Gardening, as the priority is
- 1. Cleaning,
- 2. Washing and
- 3. Gardening.
The function (formula) should deduct by priority from the Total received $170 as above.