nested if

  1. benhur1978

    Solved Excel Formula help

    Hi, Thanks in advance for any help. I trying to calculate a final commission value based on various parameters as follows... If the sales value £1000 or less then the commission is 0% From £1001 to £2999 the commission is 20% From £3000 to £5999 the commission is 25% Above £6000 the commission...
Top