Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

1. ## 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. Super Moderator
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. I agreed to these rules
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

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

#### 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