Excel Nested IF 3 Condition Formula

[yomgi]

Hello everyone,

i have 3 conditions FOR THE RESULT IN CELL V2 :

1. IF P2=1 THEN V2 =0
2. IF E2=1 THEN V2 =18+S2+T2
3. IF Q2=1;P2=0 THEN V2 =S2+T2 ELSE V2 =R2+S2+T2

http://www.freeimagehosting.net/t/tvdcx.jpg (http://www.freeimagehosting.net/tvdcx)

I want to nest the 3 conditions, can you please help for resolve this?

Thanks a lot

[Admin]

Hi yomgi,

Welcome to ExcelFox !!

Try

=IF(P2=1,0,IF(E2=1,18+S2+T2,IF(AND(Q2=1,P2=0),S2+T 2,R2+S2+T2)))

[Rick Rothstein]

Try

=IF(P2=1,0,IF(E2=1,18+S2+T2,IF(AND(Q2=1,P2=0),S2+T 2,R2+S2+T2)))
A little shorter...

=IF(P2=1,0,S2+T2+IF(E2=1,18,IF(AND(Q2=1,P2=0),0,R2 )))