Results 1 to 4 of 4

Thread: Needing help with an IF formula?

  1. #1

    Needing help with an IF formula?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Admittedly I'm hopeless with Excel, I'm desperately trying but not succeeding at this point with something. I was wondering if anyone could help possibly?

    Trying to work out how to do an IF query in Excel. Attempting to set up some basic stuff for work.

    Commission rate A 4% is in B6, Commission rate B 8% is in C6.
    Commission Limit of 1000 A is in B7 and Limit 2000 B is in C7.

    What I'm trying to work out, is how to do it so that if my guys sell enough during the week (we only run a family furniture business, starting out), how to calculate their comission.

    If B12 is where their sales go, and c12 is where I want the commission to be calculated to, how do I work it so that IF its equal to or greater than 2000, it's calculated by 8%, IF its greater than 1000 but less than 2000 the get 4%. If they sell under 1000 a week they get 0?

    I've been trying all day and just can't get it. Advice?

  2. #2
    In C12 use this formula

    =IF(B12<1000,0,IF(AND(B12>999,B12<2000),B12*B6,B12*C6))

  3. #3
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    A minor change as an alternative:

    Code:
    =IF(B12<B7,0,IF(AND(B12>=B7,B12<C7),B12*B6,B12*C6))

  4. #4

    Fantastic

    Quote Originally Posted by CheshireCat View Post
    A minor change as an alternative:

    Code:
    =IF(B12<B7,0,IF(AND(B12>=B7,B12<C7),B12*B6,B12*C6))

    It worked perfectly, thank you both so much

Posting Permissions

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