Help with complex if statement formula

[Pi*]

Hi All,

Good morning. I am trying to come up with an IF function formula or some other better formula to do the below in one column so i can copy down;

If cell G2=K, then H2
If cell G2=S, then I2
But if cell H2=0 or blank and I2=0 or blank, then J2*K2
and if K2 is blank or =0 then J2*L2

I have attached an example work sheet (Book1 - if func help).

Thank you for your assistance.

Pi

[AliGW]

Try this:

=IF(G2="K",H2,IF(G2="S",I2,IF(AND(H2=0,I2=0),J2*K2,IF(OR(K2="",K2=0),J2*L2))))

[Pi*]

Thank you for your quick response AliGW

[Glenn Kennedy]

Try this. If incorrect, please state what the expected results are:

=IF(AND(OR(H2=0,H2=""),OR(I2=0,I2="")),J2*K2,IF(OR(K2=0,K2=""),J2*L2,IF(G2="K",H2,IF(G2="S",I2))))

[Pi*]

Thank you Glenn for your response.

[Czeslaw]

=if(and(g2="k",h2<>0,h2<>""),h2,if(and(g2="s",i2<>0,i2<>""),i2,if(and(or(h2=0,h2=""),or(i2=0,i2="")),j2*k2,if(or(k2=0,k2=""),j2*l2))))

[Pi*]

Thank you Czeslaw. The formula works except for the last part of the formula which says if K2 is blank or =0 then J2*L2.
(that is if H2,I2 and K2 cells are 0 or blank but J2 and L2 have numbers, the formula results should be J2*L2.)
Currently is will show 0

Thank you for you time.

[Czeslaw]

I think your remarks corrected.

[Pi*]

Thank you very much for your time Czeslaw. You solved my question.

Happy New!