+ Reply to Thread
Results 1 to 3 of 3

Formula necessary calculating bonus over $ revenue

Hybrid View

  1. #1
    LaserDance
    Guest

    Formula necessary calculating bonus over $ revenue

    Hi guys,

    here is a question I have regarding a formula:

    pink 65 $5
    pink 42 $0
    pink 0 $0
    blue 87 $5
    blue 63 $1
    blue 5 $0
    red 26 $0
    red 4 $0
    red 9 $0

    For the first pink, blue or red which is over 50, you get $5 bonus. For the second one over 50, you get $1 bonus. If it is under 50 you don't get anything.
    I need a formula which can give me the numbers in the C column automatically.

    Thank you.

  2. #2
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Formula necessary calculating bonus over $ revenue

    Last edited by scottylad2; 11-19-2010 at 04:24 PM.
    Windows 7 using Office 2007 & 2010

    Remember your [ code ] [ /code ] tags, makes reading soooo much easier

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,006

    Re: Formula necessary calculating bonus over $ revenue

    This maybe:

    =IF(B1>=50,CHOOSE(MIN(3,SUMPRODUCT(--($A$1:A1=A1),--($B$1:B1>=50))),5,1,0),0)
    Never use Merged Cells in Excel

+ Reply to Thread

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