Calculate the month end bonus for each sales person using the following rule: Bonus is 3% if sales total for the sales person is $4000 or more. It is 1.5% if the sales total is between $2000-3999. No bonus is given for sales total less than $2000.

MS Excel

I need the total sales and bonus amount for each Only need the formula for one person and will figure it out.

Excel

Store Card N Y Y N. N Transaction ID# Dept 103180 Cameras 391615 TV 424445 TV 321265 Computers 25795 Phones 447895 Appliances 337680 Music 316575 Music 480725 Appliances 541695 Computers 227465 Cameras 504175 Cameras 213395 TV 548730 TV 553350 Phones 440045 Music 437410 Phones 374170 Appliances Salesperson Micky Jiggy Billy Jiggy Billy Kimmy Kimmy Micky Jiggy Billy Jiggy Kimmy Micky Micky Jiggy Jiggy Kimmy Billy N N Amount 416.79 2145.89 679.36 912.99 45.56 231.67 38.99 43.78 128.99 . 499.99 255.67 . 667.23 455.8 1677.77 87.69 32.15 112.16 512.49 Y N N Y N N