If and statements

D

darrenciccone

Board Regular
Joined
Sep 27, 2007
Messages
72
Hello, I will say thank you in advance for all your help.

I am working with a bonus project and I have corresponding % rates (for a certain percentage increase of unit sales; so for example if customer A bought 100 widgets last year and then this year he buys 105 he falls into the 101%-105% increase in units bought category that extra 5 units qualifies for a $ bonus based upon dollar sales of the incremntal units and I want the formula to return the appropiate % on the incremental dollar amount; so that for a range 1%-5% it Mulitplies the Incremental dollar amount by 1% and moreover if it were to change that unit volumes increased by 10% it would give back 2% on the incremental dollar purchases, and if it was 111%-115% it would be 3%.. etc.....

right now I have each % in columns and i have to manually check the % increases and it takes way too long :(


so right now there are 4 diffrent scales 101%-105% 106%-110%

111%-115% and 115% + so I need 4 arguments and I dont know where to begin :( If anyone has some insight it would be greatly appreciated and if u need more info just ask!!

Thanks again
 
Sort by date Sort by votes
I will try and post an example of what I am talking about but I have hard time pasting images on this board, I downloaded the HTMLeditor program but im not doing something right.
 
Upvote 0
I will try and post an example of what I am talking about but I have hard time pasting images on this board, I downloaded the HTMLeditor program but im not doing something right.
 
Upvote 0
Excel Workbook
ABCDEFGHIJK
1UNITS$ SALES
2**YTD Oct*YTD Oct*%*YTD Oct**
3**07*08*Change*08**
4***********
5GM*DATA'!D12]* *95,941*DATA'!F12]*101,975*6.29%*DATA'!E12]$40,658**
6FORD*DATA'!D13]*141,264*DATA'!F13]*156,655*10.90%*DATA'!E13]$60,193**
7CHRYSLER*DATA'!D14]*100,611*DATA'!F14]*108,920*8.26%*DATA'!E14]$40,605**
8HONDA*DATA'!D15]* *52,620*DATA'!F15]* *48,881*-7.11%*DATA'!E15]$15,727**
9TOYOTA*DATA'!D16]* *27,156*DATA'!F16]* *38,818*42.94%*DATA'!E16]$15,041**
10***********
11***********
12***********
13****Estimated Allowance Earned For***
14****Increasing Volume***
15****1.0%1.5%2.0%3.0%***
16***********
17GM*6.3%*$407******
18FORD*10.9%**$903*****
19CHRYSLER*8.3%**$609*****
20HONDA*-7.1%**$236*****
21TOYOTA*42.9%***$301****
22***********
23***********
24***********
25*****EST. TOTAL ALLOWANCE BONUS:$2,455****
26***********
Sheet1
 
Upvote 0
I would really like to elimate the diffrent % columns and just have it populate the bounus according to one formula!! i.e. e15 - h15 and just have one column for the bonuse and the formula contain the diffrent assumptions and %'s
 
Upvote 0
Hi, please clarify a couple of points.

1) Honda went down in unit sales, but you are still giving a bonus. Why?

2) Toyota went up by 42%, but you are not giving it top bonus. Why?
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question Question
Equitable Pricing Model
Replies
3
Views
170
kachauya
K
E
  • Question Question
Vesting Schedule - Formula/Formatting
Replies
2
Views
521
ExcelUser18
E
S
  • Question Question
Excel VBA - Sort & Get Totals - Logic
Replies
4
Views
579
STARL0RD
S
trishcollins
  • Question Question
Building a formula for a different named ranges that contain a portion of the formula
Replies
0
Views
268
trishcollins
trishcollins
R
  • Solved
maths formula help - percentage variance
Replies
2
Views
504
realsongs
R

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top