Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Excel IF function query

  1. #1
    New Member
    Join Date
    Nov 2016
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Arrow Excel IF function query

    Gross Fee $ % Rebate
    To 25000 0%
    25001 $ 50000 10%
    50001 $ 100000 15%
    100001 $ 200000 20%
    200001 $ 500000 25%
    500001 $ 10000000 30%

    Test 1: Create a spreadsheet to make this calculator work where the Gross Fee is the only input to calculate the Rebate and Net. Model needs to work for any Gross Fee input value.
    Test 2: Instead of using the visuals above, create a single formula field to calculate the Rebate and one to calculate the Net but referencing only the Gross Fee. Single formula means Rebate = Gross Fees [THE FORMULA] and Net = Gross Fees [THE FORMULA].
    Test 3: Using Test 1 and 2, calculate Rebate and Net from the Gross Fee of 9,542,332.56.
    Help: Model needs to work for any value.
    Single formula means Rebate = Gross Fees [THE FORMULA] and Net = Gross Fees [THE FORMULA].

  2. #2
    New Member
    Join Date
    Nov 2016
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel IF function query

    Help giving single formula to calculate gross fee , rebate , net

  3. #3
    Board Regular arthurbr's Avatar
    Join Date
    Dec 2006
    Location
    Zaventem
    Posts
    1,601
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel IF function query

    Is this some kind of homework?
    Please,always use a relevant keyword thread title that describes what you are trying to do
    Using XL2003 - 2010

  4. #4
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    8,250
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel IF function query

    have a read over LOOKUP
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  5. #5
    New Member
    Join Date
    Nov 2016
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel IF function query

    yes this is project please help giving excel formula asap

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com