if condition excel formula from 4 cells values result as of conditions of two cells

[breadwinner]

dear experts

I need your help on if conditions works depends upon two column values!! Like

I have ZONE LIST in A:A column , and SLD IN B:B column,,,,


A:A column contains of -,A,B,C,D
SLD Column constians of ND,2BD,3BD,4BD,5BD

condition is if A Meets - and if B Meets ND I want calculate INT(D2)-INT(C2)
condition is if A Meets A and if B Meets ND I want calculate INT(D2)-INT(C2)
condition is if A Meets B and if B Meets 2BD OR 3,OR 4,OR 5 I want calculate INT(D2)-INT(C2)-1
condition is if A Meets C and if B Meets 2BD OR 3,OR 4,OR 5 I want calculate INT(D2)-INT(C2)-1
condition is if A Meets D and if B Meets 2BD OR 3,OR 4,OR 5 I want calculate INT(D2)-INT(C2)-1

One more thing if INT(D2)-INT(C2) result is like 41589,-41589, or D2 and C2 Is blank i want result blank.

find the attachment

[:) Sixthsense :)]

Why not like this?

In E2 Cell

=IF(COUNT(C2:D2)=2,IF(A2<>"A",(D2-C2)-1,(D2-C2)),"")

Drag it down…

[breadwinner]

Thanks Dude Ever for you help Sixsense....Solved

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback