Forum Discussion
Microsoft Excel - Updates to Calculation
Current formula is just adding up different numeric values, but I need to add some additional logic and can use some assistance.
=B2+F2+H2+I2+J2+M2+N2+P2
1) If Column K = "Set Date", I would like the above formula to be updated to output a '-'.
2) If Column BA = "Group" or "Order", I would like the above formula to be updated to output a '-'.
3) If Column G = "As-Is(No Changes)" AND Column BA = "Override", I would like the above formula to be updated to output '0.2'.
| Column G | Column K | Column BA | Current Calculation | Updated Calculation |
| Set Date | 5.1 | - | ||
| Group | 3.8 | - | ||
| Order | 31.2 | - | ||
| As-Is(No Changes) | Override | 31.4 | 0.2 | |
| Modified | Normal | 22.2 | 22.2 | |
| Modified | Set Date | Override | 21.0 | - |
| New | Group | 31.9 | - | |
| Modified | Normal | 18.2 | 18.2 |
6 Replies
=IF(OR(K2="Set Date",BA2="Group",BA2="Order"),"-",IF(AND(G2="As-Is(No Changes)",BA2="Override"),0.2,B2+F2+H2+I2+J2+M2+N2+P2))
When using the updated formula, there is one update.
In cases where Column G = "As-Is(No Changes)" AND Column BA = "Override", regardless of Column K, or Column BA, I would like that to result in '0.2' before the other logic.
Can this be updated?
Simply change the order of the conditions:
=IF(AND(G2="As-Is(No Changes)",BA2="Override"),0.2,IF(OR(K2="Set Date",BA2="Group",BA2="Order"),"-",B2+F2+H2+I2+J2+M2+N2+P2))
