jeudi 1 juillet 2021

If checkbox is checked then delete multiple cell value. Any solution?

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