+ Reply to Thread
Results 1 to 3 of 3

Formula for calculating staff incentive

  1. 08-29-2016, 11:16 AM #1
    yseinnob
    yseinnob is offline
    Registered User
    Join Date
    08-29-2016
    Location
    Singapore
    MS-Off Ver
    Mac
    Posts
    2

    Formula for calculating staff incentive

    Hi everyone. I have been stuck with this for an hour now, and I need help with figuring out what's wrong with my formula.
    Reply With QuoteRegister To Reply
  2. 08-29-2016, 11:17 AM #2
    yseinnob
    yseinnob is offline
    Registered User
    Join Date
    08-29-2016
    Location
    Singapore
    MS-Off Ver
    Mac
    Posts
    2

    Re: Formula for calculating staff incentive

    =IF(E3="room",(F3*G3)*10%),IF(E3=“breakfast",(F3*G3)*8%))
    Reply With QuoteRegister To Reply
  3. 08-29-2016, 11:17 AM #3
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello yseinnob,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for calculating staff incentive
    By yseinnob in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-29-2016, 11:17 AM
  2. IF Function for calculating Sales Incentive
    By pranjal79 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2016, 04:27 AM
  3. calculating incentive fees
    By OmarHamza in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-23-2016, 07:54 AM
  4. [SOLVED] Calculating the average no. of staff per week
    By FredFitzgerald in forum Excel General
    Replies: 9
    Last Post: 08-12-2014, 11:58 AM
  5. [SOLVED] calculating cumulative daily overtime for 20+ staff.
    By Tim1576 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2014, 07:02 AM
  6. [SOLVED] Calculating Range with IF formula for Incentive Calculation
    By kishoresp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2013, 01:45 AM
  7. Array Formula - Calculating Staff Numbers
    By Saxifrage in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2007, 02:01 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1