Need Help for this Formula
I use this formula in excel to get P.Tax from gross. "M6" is gross. =IF(AND(M6>3501,M6<10001),0,IF(AND(M6>10001,M6<150 01),110,IF(AND(M6>15001,M6<25001),130,IF(AND(M6>25 001,M6<40001),150,IF(M6>40001,200,0)))))
Now can anyone help me how i use this type of formula in access?
