Forum Discussion
FORMULAS
I HAVE TO SPLIT G6 INTO D6 AND E6 I.E -600 AND -150 RESPECTIVELY , PLEASE HELP ME. FILE ATTACHED
If logic is as here https://techcommunity.microsoft.com/t5/Excel/formula-for-data-calculation/m-p/804693, when in D6
=IF( (B6-C6=-600) + (B6-C6=-750),-600,"")in E6
=IF(AND(B6-C6>=-200,B6-C6<=-1),B6-C6,IF(B6-C6=-750,-150,""))and in G6
=B6-C6-SUM(D6:F6)