Possible nested IF formula...

[yekom]

Ok, I'll try to be as detailed as possible.

These are the cells and values:

A1 - 120
A2 - 340
A3 - 110
A4 - 110
A5 - 110
A6 - 110

Ok I've taken cell B1 to calculate A2-A1, and then B2 to calculate A3-A2. I'll skip cell B3 because I've taken care of that formula.

Now, here is my problem. I'm looking for a formula for my cell B4 that can say: if my A4 value is equal to A3 and A5, then display cero in this celI. If A4 is not equal to A3 or A5, then I can continue to subtract A4-A3. But if A4 is ONLY equal to A5 then subtract A1-A4

I hope that helps.