- Based on a validation, if A1 = 20, then B1 = 5.
- Based on a formula, B2, B3, B4, B5, B6, and B7 = B1.
Except, I want B2:B6 to equal B1 + D1, if C1 = True.
My question is: How do I make it so that the formula for one cell (B2) equals the sum of two cells (B1,D1) in the event that a third cell (C1) has a True value? If it is False, I want it (B2) to just equal the sum of one cell (B1).
Aucun commentaire:
Enregistrer un commentaire