Dear Good people,

Please help me to add these 2 formulas to work on one cell

=(-A3+11)-C3

=IF(AA2="Sun",0,IF(AA2="",11,))-AE5

The idea is


A (5) B (12) C(7) D((11-7)=3) E(2) F(Sun)

If i subtruct A from B it should give me the answer on C, which is 7
and 7 must subtruct from D(11), if i put any figure on E which is 2, must subtruct from 3 on D and leave D with the balance of 1. But when i put "Sun" on F, the D should be equal to "0" but C must still give me the answer (B-A)

Best Regards,