I'm making a budget template and it will be grateful to get some helps.
Column A: Name of the customers
Column B: Number of clothes (dropdown list from 0 to 10)
Column C: Price
Column D: Refund (checkbox cell linked in itself)
A and B values are input, so I fill them in the cell or select in the dropdown list.
C will be then automatically filled in with VLOOKUP function.
If the product is returned and so checkbox in D is checked, then the corresponding price will turn to 0 with IF function.
I want A and B erased or make them also 0 not to count anymore.
Is there any solution?
Aucun commentaire:
Enregistrer un commentaire