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.

State Code <tbody> </tbody>	Rate of Gst <tbody> </tbody>	Total Amount <tbody> </tbody>	IGST <tbody> </tbody>	CGST	SGST
PTN	18%	100000	18000	0	0
DLH	5%	100000	0	2500 (2.5%)	2500 (2.5%)

<tbody>
</tbody>

There are total 22 State code

State Code

PTN

NGP

BPL

RPR

VNS

VJV

BLR

JAI

LUK

HYD

DHD

DLH

CHN

CHI

BHW

MHP

ANE

KCH

HRY

KOL

VDR

RCH

<colgroup><col></colgroup><tbody>
</tbody>

 

[mole999]

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