want a little gift from som on account of new years day.

This Question is empty.

Viewing 5 posts - 1 through 5 (of 5 total)

Author

Posts
April 14, 2012 at 3:34 am #67363

unknown
Participant

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.

April 14, 2012 at 7:59 am #72015

unknown
Participant

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))))))))

April 14, 2012 at 9:06 am #72017

unknown
Participant

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.

April 14, 2012 at 10:27 am #72018

unknown
Participant

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.

April 14, 2012 at 10:39 am #72019

unknown
Participant

Thanks for the thanks
On behalf of my family and myself too
Author

Posts

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this Question.