Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if command with tiers
I have 10 levels of tiers I am trying to use an if then command with, I keep
getting an error after the 9th line. As I am entering the 10th if command into the function, it stops highlighting the links and keeps sending me back to the last if command in the formula. I hope this doesn't sound too confusing...I am so fried from trying to figure this out. Here is my formula: =if(MTAABB22,D23,if(MTAABB23D24,if(MTAABB24,D2 5,if(MTAABB25,D26,if(MTAABB26,D27,if(MTAABB27,D 28,if(MTAABB28,D29,if(MTAABB29,D30,if(MTAABB30, D31))))))))' Mtaab is just a named cell. Ticket Average % Potential Pay Out $- $13.49 0.00% $- $13.50 $15.49 2.50% $1,901.02 $15.50 $16.49 3.50% $2,661.43 $16.50 $17.49 4.50% $3,421.84 $17.50 $18.49 5.50% $4,182.25 $18.50 $19.49 6.50% $4,942.65 $19.50 $20.49 7.50% $5,703.06 $20.50 $21.49 8.50% $6,463.47 $21.50 $22.49 9.50% $7,223.88 $22.50 + 10.50% $7,984.29 The end result needs to be the "potential pay out." Please help me! Thanks! Jenna |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if command with tiers
JennaOG wrote:
I have 10 levels of tiers I am trying to use an if then command with, I keep getting an error after the 9th line. As I am entering the 10th if command into the function, it stops highlighting the links and keeps sending me back to the last if command in the formula. I hope this doesn't sound too confusing...I am so fried from trying to figure this out. Here is my formula: =if(MTAABB22,D23,if(MTAABB23D24,if(MTAABB24,D2 5,if(MTAABB25,D26,if(MTAABB26,D27,if(MTAABB27,D 28,if(MTAABB28,D29,if(MTAABB29,D30,if(MTAABB30, D31))))))))' Mtaab is just a named cell. Ticket Average % Potential Pay Out $- $13.49 0.00% $- $13.50 $15.49 2.50% $1,901.02 $15.50 $16.49 3.50% $2,661.43 $16.50 $17.49 4.50% $3,421.84 $17.50 $18.49 5.50% $4,182.25 $18.50 $19.49 6.50% $4,942.65 $19.50 $20.49 7.50% $5,703.06 $20.50 $21.49 8.50% $6,463.47 $21.50 $22.49 9.50% $7,223.88 $22.50 + 10.50% $7,984.29 The end result needs to be the "potential pay out." Please help me! Thanks! Jenna Depending upon the version of Excel you are using, there is a limit of 7 nested IF() functions. Look at this: http://www.contextures.com/xlFunctions03.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if command with tiers
I have 10 levels of tiers I am trying to use an if then command with,
I keep getting an error after the 9th line. ... Ticket Average % Potential Pay Out $- $13.49 0.00% $- $13.50 $15.49 2.50% $1,901.02 $15.50 $16.49 3.50% $2,661.43 $16.50 $17.49 4.50% $3,421.84 $17.50 $18.49 5.50% $4,182.25 $18.50 $19.49 6.50% $4,942.65 $19.50 $20.49 7.50% $5,703.06 $20.50 $21.49 8.50% $6,463.47 $21.50 $22.49 9.50% $7,223.88 $22.50 + 10.50% $7,984.29 The end result needs to be the "potential pay out." Here is my formula: =if(MTAABB22, ... Mtaab is just a named cell. Another way to approach the problem is something like this: =VLOOKUP(MTAAB,A:D,4,TRUE) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button add another command | Excel Discussion (Misc queries) | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Pricing Tiers Help | Excel Discussion (Misc queries) | |||
How can I enter a value and obtain an average based upon tiers. | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |