if function in excel

praveenr22 · #1 (**permalink**) 20-11-2007, 06:39 PM

Hi All,
I should put professional tax slab in excel. Slab for professional tax in bangalore are till 3000 its nil;from 3000 to 4999 its 30Rs;from5000 to 7999 its 60Rs; from 8000 to 9999 its 100Rs;from 10000 to 14999 its 150Rs; above 15000 its 200Rs. So please guide me to apply this slab into formula in excel sheet.

regards,
Praveen

nilendrachand · #2 (**permalink**) 20-11-2007, 07:01 PM

Pl use this formula,

=IF(A1>=15000,"200",IF(A1>=10000,"150",IF(A1>=8000 ,"100",IF(A1>=5000,"60",IF(A1>=3000,"30",IF(A1>=0, "0"))))))

I hope this solves your query

Regards,
Nilendra

praveenr22 · #3 (**permalink**) 21-11-2007, 12:49 PM

Hi Nilendra,

Thanks for your help

regards
Praveen

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode