Results 1 to 6 of 6

calulating multiple % rates

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Wimauma, Fl
    MS-Off Ver
    Excel 2003
    Posts
    3

    calulating multiple % rates

    ok here is what I need help with , a formula for:

    if F is less than 75% then G needs to be $0
    If F is between 75 and 85% then G needs to be $15
    If F is between 85 and 99% then G needs to be $30
    If F is 100% or greater then G need to be $100

    So I've done single percents =IF(E7>F7,100,0) Basically they sell 100 percent of goal (E being sales , F being sales goal) get $100 bonus , so G would be $100 bonus they earned
    But have never done one that has different bonus levels like this.
    Last edited by Whymama; 05-07-2012 at 12:23 AM. Reason: clarification

Thread Information

Users Browsing this Thread

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

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