Purchase Solution

Spreadsheet using IF / AND functions for employee bonus pay

Not what you're looking for?

Ask Custom Question

See attached file.

In the attachment, I need help with how to use the "AND" and "IF" formula.

The IF formula is needed to enter the bonus amounts if a person is eligible.

An employee with a performance rating of seven or higher and who meets the sales quota receives a bonus of one percent of the sales.

If the rating is less than seven, or if the sales amounts are less than the quota, no bonus is awarded.

Attachments
Purchase this Solution
Solution Summary

The expert examines Excel spreadsheets using IF/AND functions for employee bonus pay award.

Purchase this Solution
Free BrainMass Quizzes
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

View More Free Quizzes
Related BrainMass Solutions

  • Excel Spreadsheet: Payroll Calculator

    The Commission Earned, Hourly Pay Earned (for the two hourly employees), and Payroll Amount columns require you to use IF functions.

  • Building a Simple Expert System for Retirement Planning

    To receive a bonus, an employee must be at least 50 years of age and have worked for the company for 5 years.

  • Excel Payroll Spreadsheet

    These calculations must be completed using a formula. 8.Calculate the totals for all of the employee hours and pay categories in the range: B16:I16.

  • Create a Worksheet in an Excel Spreadsheet for Payroll and Commission

    You now have the expertise needed to automate this task by using formulas and functions in an Excel spreadsheet.

  • The Benefits of Referral Bonuses

    What kinds of restrictions should be placed on the program if you recommend it? I think that it is a good idea for companies to pay current employees a referral bonus if a job candidate that the employee referred, is hired by the company.

  • Java Employee Payroll Problem

    Include a getEarnings method that calculates earnings for an hourly employee. Hourly employees are paid by the hour. If they work more than 40 hours in a week, then they receive overtime pay for their overtime work.

  • Accounting Project in Excel

    Two of the five employees are eligible for 3% commission based on fitness equipment sales 3. Write and copy formulas and functions to show: a. For each employee: 1. Gross pay 2.

  • Spreadsheet Creation for Sales Management

    The Commission Earned, Hourly Pay Earned (for the two hourly employees), and Payroll Amount columns require you to use IF functions.

  • TOTAL REWARDS; EMPLOYEE & LABOR RELATIONS; GLOBAL HR - King

    The focus was to determine if employees would accept less health coverage but continue with insurance fully paid by King or if they preferred to pay a portion of their premium and maintain the same benefit coverage as in the past.

View More Related Solutions