Results 1 to 7 of 7

Multiple IF(AND) Statements

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    Brookings, SD
    MS-Off Ver
    Excel 2013
    Posts
    3

    Multiple IF(AND) Statements

    I am attempting to calculate a commission based on the range that the number falls in between. I keep getting a #value error.

    C1= $15
    C2= $1,000,000
    C5= $0.00
    D5= .75%
    B6= $.01
    C6= $15.00
    D6= 2.00%
    B7= $15.01
    C7 = $50.00
    D7 = 2.50%
    B8= $50.01
    D8= 3.00%
    This is the formula that I have
    =IF(C1<=C5,C2*D5),IF(AND(C1>=B6,C6<=C1),C2*D6),IF(AND(C1>=B7,C1<=C7),D7*C2),IF(C1>=B8,D8*C2,0)
    Last edited by kevin_evan; 05-07-2013 at 03:21 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1