As the title says, I want to subtract n from min value first and then the remainder of n from the max value. I thought I had it cracked until one of the values exceeds n.
My formula is =IF(C4=D4,C4-(B/2),IF(C4<D4,MIN(SUM(C4:D4)-B4,0),MAX(SUM(C4:D4)-B4,0))) for bot AA and BB.
<d4,min(sum(c4:d4)-b4,),max(sum(c4:d4)-b4,0)))
The expected result in E4 (AA) should be 100 and F4 (BB) should be 69 but as you can see it falls over. Can anyone make a suggestion?
<tbody>
</tbody></d4,min(sum(c4:d4)-b4,),max(sum(c4:d4)-b4,0)))
My formula is =IF(C4=D4,C4-(B/2),IF(C4<D4,MIN(SUM(C4:D4)-B4,0),MAX(SUM(C4:D4)-B4,0))) for bot AA and BB.
<d4,min(sum(c4:d4)-b4,),max(sum(c4:d4)-b4,0)))
The expected result in E4 (AA) should be 100 and F4 (BB) should be 69 but as you can see it falls over. Can anyone make a suggestion?
(A1) | (B1) n | (C1) a | (D1) b | (E1) aa | (F1) bb |
(A2) | 30 | 20 | 25 | 0 | 15 |
(A3 | 30 | 17 | 14 | 1 | 0 |
(A4) | 30 | 100 | 99 | 169 (Exp 100) | 0 (Exp 69) |
<tbody>
</tbody>