WBXPress

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

Home › Forums › Excel Utility › want a little gift from som on account of new years day.

  • This topic is empty.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • April 14, 2012 at 3:34 am #67363
    Anonymous
    Inactive

    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
    Anonymous
    Inactive

    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
    Anonymous
    Inactive

    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
    Anonymous
    Inactive

    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
    Anonymous
    Inactive

    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 topic.