Formula Assistance

I want to calculate the same figure with two different formula.

I have attached a sheet where I have put if formula where i want the required result.

Pls assist.

Hi,

I'm not quite understand. Can you elaborate little more ?

I have two set of formulas in H & I column and i want both of them give me same results.e.g column H has =IF(AND($C$2<>0,$E2<>0),IF(IF($B2="51",0,IF($A2="1 ",(($F2-$G2)*$D2%),$K2))<0,0,IF(AND($C2<>0,$E2<>0,IF($E2=0 ,0,IF($B2="51",0,IF($A2="1",(($F2-$G2)*$D2%),$K2)))),0))) with some more test but it gives false.

thanks

Are you looking for this?

=IF(AND($C$2<>0,$E2<>0),IF(IF($B2="51",0,IF($A2="1 ",(($F2-$G2)*$D2%),$K2))<0,0,IF(AND($C2<>0,$E2<>0,IF($E2=0 ,0,IF($B2="51",0,IF($A2="1",(($F2-$G2)*$D2%),$K2)))),0)),IF($A2="2",$K2,($F2-$G2)*$D2/100))

If not, I can't seem to understand your query.