Thanks dear friend for calling me an expert though I am not the same
2. How I put if function in Excel for calculation of P.Tax (W.B. Rate).
say you have the gross amount in Cell A1.
Formula: =IF(A1>=40000,200,IF(A1>=25000,150,IF(A1>=15000,130,IF(A1>=9000,110,IF(A1>8000,90,IF(A1>7000,50,IF(A1>6000,45,IF(A1>5000,40,30))))))))