+ Reply to Thread
Results 1 to 3 of 3

For every "point" above X do Y

  1. #1
    Registered User
    Join Date
    09-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    8

    For every "point" above X do Y

    Hi there Excel geniuses!

    I want to pay salespeople a bonus when they sell things at a higher Gross Profit. There is a minimum markup. I want to say for every additional point above the floor (F) well pay (B*C). There is also the actual attainment filed (A). For this example lets say the floor (F) is 22% and the actual attainment is 26%.

    Illustrations:
    .22 = 0(B*C)
    .23 = 1(B*C)
    .24 = 2(B*C)
    A = .26
    F= .22

    What I want is:
    if A >= F THEN for EACH POINT above the floor add 1*(B*C)

    Its actually buried in a larger IF(AND function and I need to be able to drag the function down a long column and have it scale with volume sold. But its just this bit of logic I'm hung up on.

    Thank you for reading!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: For every "point" above X do Y

    if A and F are both "number of percents"
    Please Login or Register  to view this content.
    if both are percents (values from 0-1 range shown as 0-100%):
    Please Login or Register  to view this content.
    if some of it is the same for all salespeople (say F) then use absolute row address (F$1).
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    09-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: For every "point" above X do Y

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  2. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  3. Replies: 2
    Last Post: 10-06-2007, 01:26 PM
  4. Replies: 7
    Last Post: 05-13-2006, 05:02 PM
  5. [SOLVED] [SOLVED] Use the "mouse over" event to exclude a data point from a series
    By Randall Hiltz in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 01-19-2005, 04:06 PM

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