If Function with multiple criteria for tax calculation

[hardeep.kanwar]

Hi Everyone

I need help on "If" function

I have multiple State codes, Tax rate, Amount and Tax applied i.e. IGST ,CGST,SGST,What i need if State code is not Equal to "DLH" Than tax should be IGST,if State code is equal to DLH than tax should be CGST AND SGST.

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 103"]
<tbody>[TR]
[TD="class: xl65, width: 103"]State Code[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="class: xl66, width: 49"]Rate of
Gst[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 100"]
<tbody>[TR]
[TD="class: xl65, width: 100"]Total
Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]IGST[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]CGST[/TD]
[TD]SGST[/TD]
[/TR]
[TR]
[TD]PTN[/TD]
[TD]18%[/TD]
[TD]100000[/TD]
[TD]18000[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]DLH[/TD]
[TD]5%[/TD]
[TD]100000[/TD]
[TD]0[/TD]
[TD]2500 (2.5%)[/TD]
[TD]2500 (2.5%)[/TD]
[/TR]
</tbody>[/TABLE]

There are total 22 State code

[TABLE="width: 103"]
<colgroup><col></colgroup><tbody>[TR]
[TD]State Code[/TD]
[/TR]
[TR]
[TD]PTN[/TD]
[/TR]
[TR]
[TD]NGP[/TD]
[/TR]
[TR]
[TD]BPL[/TD]
[/TR]
[TR]
[TD]RPR[/TD]
[/TR]
[TR]
[TD]VNS[/TD]
[/TR]
[TR]
[TD]VJV[/TD]
[/TR]
[TR]
[TD]BLR[/TD]
[/TR]
[TR]
[TD]JAI[/TD]
[/TR]
[TR]
[TD]LUK[/TD]
[/TR]
[TR]
[TD]HYD[/TD]
[/TR]
[TR]
[TD]DHD[/TD]
[/TR]
[TR]
[TD]DLH[/TD]
[/TR]
[TR]
[TD]CHN[/TD]
[/TR]
[TR]
[TD]CHI[/TD]
[/TR]
[TR]
[TD]BHW[/TD]
[/TR]
[TR]
[TD]MHP[/TD]
[/TR]
[TR]
[TD]ANE[/TD]
[/TR]
[TR]
[TD]KCH[/TD]
[/TR]
[TR]
[TD]HRY[/TD]
[/TR]
[TR]
[TD]KOL[/TD]
[/TR]
[TR]
[TD]VDR[/TD]
[/TR]
[TR]
[TD]RCH[/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

make a table on a separate sheet and use VLOOKUP it will be quicker than modifying an IF statement