i have to write some formula ta transformation level but is not working. i am facing always syntax errors.
please look at the data
sample dataTypeCategoryunitsMax UnitsFixed Charge (Rs/HP/Month)Demand Charge (Rs/kVA/Month)Energy Charge (Rs/unit)LTLT1Slab 1 (0-50)501.45LTLT1Slab 2 (51-100)1002.8LTLT1Slab 3 (101-200)2003.05LTLT1Slab 4 (201-300)3004.75LTLT1Slab 5 (>300)3015.5LTLT2Slab 1 (0-50)503.85LTLT2Slab 2 (51-100)1006.2LTLT2Slab 3 (>100)1016.5
here consumer type have only LT and category have different (LT1,LT2,LT3) and different slabs (0-50, 51-100, 101-200,201-300, above 300)
my requirement is
if type is LT and if category is LT1 and slab is ( 0-50) = charge 1.45
if type is LT and if category is LT1 and slab is ( 51- 100) = charge 2.8
if i write the formula or routine is best performance please suggest.