- This Question is empty.
Viewing 5 posts - 1 through 5 (of 5 total)
Viewing 5 posts - 1 through 5 (of 5 total)
- You must be logged in to reply to this Question.
FORUM of WBXPRESS.COM
Discussion Forum of WBXPRESS › Forums › Excel Utility › want a little gift from som on account of new years day.
Friend,
Your are an expert on computer application but your friend nothing. Now give me two gift for the day.
Give the formula :- 1. How I put in Excel with 3% increment from July ( periodical Increment).
2. How I put if function in Excel for calculation of P.Tax (W.B. Rate).
Now I am awaiting . with regards.
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))))))))
How I put in Excel with 3% increment from July ( periodical Increment).
Actually this is not possible through a single formula. As we know necessity is the mother of invention, I tried to create it and succeeded. I am uploading herewith an excel sheet which will give you clear directions and help you in this regard.
Friend,
It is very fine gift near me. Lots of thank but not only for you, please share it with your family.Don’t mind.
Thanks for the thanks
On behalf of my family and myself too
Acts, Rules, Regulations, Resolutions, Notifications, Circulars, Memorandum, Guidelines, Govt. Orders etc. from various department of the Government of West Bengal. About
ASKWB.com is the discussion section of WBXPRESS.com where more than 7,400 users are connected till date. There are 24 forums which covers all your query. If you have any question please ask here in this forum.