View Single Post
  #4 (permalink)  
Old April 6th, 2018, 12:39 PM
shadowabhi12345 shadowabhi12345 is offline
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2018
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?
Reply With Quote