Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Exceeding 7 Calculations
I'm trying to have a calculation executed, but it has more than 8
arguements. What I need is the following, given a certain quota (I'll have 6 different quotas to be looked up), find that range and then execute the calculation. I have 13 different ranges and 13 different calculations corresponding. I read that I can use a lookup, but I would rather write a macro, but I have no idea where to start. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Exceeding 7 Calculations
It would helpful if we knew what calculations are to be done on what data!
"wilma2299" wrote: I'm trying to have a calculation executed, but it has more than 8 arguements. What I need is the following, given a certain quota (I'll have 6 different quotas to be looked up), find that range and then execute the calculation. I have 13 different ranges and 13 different calculations corresponding. I read that I can use a lookup, but I would rather write a macro, but I have no idea where to start. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Exceeding 7 Calculations
Look in vba help index for select case
-- Don Guillett SalesAid Software "wilma2299" wrote in message oups.com... I'm trying to have a calculation executed, but it has more than 8 arguements. What I need is the following, given a certain quota (I'll have 6 different quotas to be looked up), find that range and then execute the calculation. I have 13 different ranges and 13 different calculations corresponding. I read that I can use a lookup, but I would rather write a macro, but I have no idea where to start. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Exceeding 7 Calculations
Thank you for responding so quickly! The calculations are as follows:
Let's say the profit was $57848 and the quota was $62500 making the quota met 92%. This falls into the quota range of 90 - 94, and therefore it would be calculated: (57848*.95)+(57848*.475) where .95 and .475 change with every quota range and I have 13 quota ranges. I really appreciate the assistance!! On Jun 13, 1:42 pm, Mike H wrote: It would helpful if we knew what calculations are to be done on what data! "wilma2299" wrote: I'm trying to have a calculation executed, but it has more than 8 arguements. What I need is the following, given a certain quota (I'll have 6 different quotas to be looked up), find that range and then execute the calculation. I have 13 different ranges and 13 different calculations corresponding. I read that I can use a lookup, but I would rather write a macro, but I have no idea where to start. Thanks!- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Exceeding 7 Calculations
I should look where?
On Jun 13, 1:54 pm, "Don Guillett" wrote: Look in vba help index for select case -- Don Guillett SalesAid Software "wilma2299" wrote in message oups.com... I'm trying to have a calculation executed, but it has more than 8 arguements. What I need is the following, given a certain quota (I'll have 6 different quotas to be looked up), find that range and then execute the calculation. I have 13 different ranges and 13 different calculations corresponding. I read that I can use a lookup, but I would rather write a macro, but I have no idea where to start. Thanks!- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Exceeding 7 Calculations
On Jun 13, 2:32 pm, "Don Guillett" wrote:
You still didn't give too much info but this is the idea. Sub selectcasevalues() Select Case ActiveCell.Value Case Is 94: x = 0.95 + 0.475 Case Is 100: x = 1.2 + 5 'etc Case Else End Select ActiveCell.Offset(, 1) = Range("o11") * x End Sub -- Don Guillett SalesAid Software "wilma2299" wrote in message ups.com... I should look where? On Jun 13, 1:54 pm, "Don Guillett" wrote: Look in vba help index for select case -- Don Guillett SalesAid Software "wilma2299" wrote in message groups.com... I'm trying to have a calculation executed, but it has more than 8 arguements. What I need is the following, given a certain quota (I'll have 6 different quotas to be looked up), find that range and then execute the calculation. I have 13 different ranges and 13 different calculations corresponding. I read that I can use a lookup, but I would rather write a macro, but I have no idea where to start. Thanks!- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Let me see if i can make it a little more clear. I have six different regions. There are different tiers of quota's that when met, calculate different bonus payouts for each region. Does that clear up anything? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Exceeding 7 Calculations
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Exceeding 7 Calculations
On Jun 14, 12:33 am, "Don Guillett" wrote:
Not really -- Don Guillett SalesAid Software "wilma2299" wrote in message oups.com... On Jun 13, 2:32 pm, "Don Guillett" wrote: You still didn't give too much info but this is the idea. Sub selectcasevalues() Select Case ActiveCell.Value Case Is 94: x = 0.95 + 0.475 Case Is 100: x = 1.2 + 5 'etc Case Else End Select ActiveCell.Offset(, 1) = Range("o11") * x End Sub -- Don Guillett SalesAid Software "wilma2299" wrote in message roups.com... I should look where? On Jun 13, 1:54 pm, "Don Guillett" wrote: Look in vba help index for select case -- Don Guillett SalesAid Software "wilma2299" wrote in message groups.com... I'm trying to have a calculation executed, but it has more than 8 arguements. What I need is the following, given a certain quota (I'll have 6 different quotas to be looked up), find that range and then execute the calculation. I have 13 different ranges and 13 different calculations corresponding. I read that I can use a lookup, but I would rather write a macro, but I have no idea where to start. Thanks!- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Let me see if i can make it a little more clear. I have six different regions. There are different tiers of quota's that when met, calculate different bonus payouts for each region. Does that clear up anything? Could;nt you use dcount ? Excel's in built help has some example.. how i have done this in the past is to actually create a range of criteria's specific to each if statement and use that in the formula.. it has some limitations though.. i will let you explore the help, ;-) |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Exceeding 7 Calculations
On Jun 13, 3:33 pm, "Don Guillett" wrote:
Not really -- Don Guillett SalesAid Software "wilma2299" wrote in message oups.com... On Jun 13, 2:32 pm, "Don Guillett" wrote: You still didn't give too much info but this is the idea. Sub selectcasevalues() Select Case ActiveCell.Value Case Is 94: x = 0.95 + 0.475 Case Is 100: x = 1.2 + 5 'etc Case Else End Select ActiveCell.Offset(, 1) = Range("o11") * x End Sub -- Don Guillett SalesAid Software "wilma2299" wrote in message roups.com... I should look where? On Jun 13, 1:54 pm, "Don Guillett" wrote: Look in vba help index for select case -- Don Guillett SalesAid Software "wilma2299" wrote in message groups.com... I'm trying to have a calculation executed, but it has more than 8 arguements. What I need is the following, given a certain quota (I'll have 6 different quotas to be looked up), find that range and then execute the calculation. I have 13 different ranges and 13 different calculations corresponding. I read that I can use a lookup, but I would rather write a macro, but I have no idea where to start. Thanks!- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Let me see if i can make it a little more clear. I have six different regions. There are different tiers of quota's that when met, calculate different bonus payouts for each region. Does that clear up anything?- Hide quoted text - - Show quoted text - I guess we could start with just a macro that can execute a series of 13 if statement conditions... |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If Exceeding 7 Calculations
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exceeding columns limit | Excel Discussion (Misc queries) | |||
Exceeding the limit for Nested IFs | Excel Worksheet Functions | |||
Exceeding 65,000 rows | Excel Discussion (Misc queries) | |||
Data calculations require more than 7 nested functions | Excel Worksheet Functions | |||
Data calculations require more than 7 nested functions | Excel Worksheet Functions |