Monica S G
New Member
- Joined
- Sep 13, 2023
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi Team,
What formula is used when any of the column is deleted from the sheet and that equal to 100%?
For example:
C1 C2 C3 C4 C5 C6 C7
15% 10% 15% 20% 30% 10% = 100% (Sum is 100%)
If C3 and C5 column us deleted, it should automatically consider 100% in the C7 column. Please provide the insights on the same.
What formula is used when any of the column is deleted from the sheet and that equal to 100%?
For example:
C1 C2 C3 C4 C5 C6 C7
15% 10% 15% 20% 30% 10% = 100% (Sum is 100%)
If C3 and C5 column us deleted, it should automatically consider 100% in the C7 column. Please provide the insights on the same.