Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Conditional Percentage Calculation

  1. #1
    Join Date
    17th January 2005
    Location
    Herts, UK
    Posts
    23

    Conditional Percentage Calculation

    Hi all

    I 'm really struggling here and would appreciate any help!
    I'm trying to get an IF statement that will calculate commision.
    If a margin on a particular sale is 35% or below, then commision is 0%. If margin is between 36 and 37 %, then commision is 1%, etc...
    Is this doable?? It's been driving me mad all day today.

    Many thanks

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: If Statement Percentage Calculation

    Hi,

    Try something like..

    =LOOKUP(A1,{0,0.36,0.38},{0,0.01,0.02})

    HTH

  3. #3
    Join Date
    2nd August 2008
    Posts
    7

    Re: If Statement Percentage Calculation

    Try this:
    Assuming cell A2 contains the margin percent.

    =IF(A2<=35%,0%,FLOOR(A2-35%,.01))

    Note: The FLOOR function rounds down to the next lower whole percentage point. If you wish to allow for fractions of a percent then simply replace the FLOOR function with A2-35%.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Percentage Calculation Based On Months & Dates
    By jeff45123 in forum Excel General
    Replies: 7
    Last Post: June 10th, 2008, 01:59
  2. If Percentage Calculation Negative Show Zero
    By STPETER08 in forum Excel General
    Replies: 4
    Last Post: October 22nd, 2007, 09:56
  3. Error In Percentage Calculation
    By jshayler in forum Excel General
    Replies: 3
    Last Post: January 30th, 2007, 07:18
  4. Percentage Calculation ?
    By piazope in forum Excel General
    Replies: 2
    Last Post: January 12th, 2006, 22:42
  5. Percentage of times calculation query
    By stevehorton09 in forum Excel General
    Replies: 1
    Last Post: July 9th, 2004, 22:18

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
  •  
porno