locked
Commission calculation in visual basic 2010 RRS feed

  • Question

  • Hi There

    Can somebody assist me here, I have trying create a program to calculate sales commission per person weekly. I'm not sure whether to use IF or Case approach. The senario is as follows: Given Commission rate=.13, Base pay=&100 and the sales quota=500 meaning commission is earned only for sale greater or equal to 500 items.

    Thursday, July 12, 2018 7:52 AM

All replies

  • The commission is applied to sales over 500.

    So you need to subtract 500 from the total sales and if the remainder is larger than zero you apply the commission percentage to the remainder.

    I did not say select case larger than zero did I?

    Although you could use either one.

    Why dont you do it both ways and tell us which one you like best and why?

    • Proposed as answer by Reed KimbleMVP Thursday, July 12, 2018 1:24 PM
    Thursday, July 12, 2018 8:54 AM
  • Noted I will try both

    Thanks

    Friday, July 13, 2018 8:37 AM