Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Else Formula for Excel Worksheet
I need a formula that evaluates a cell and if that cell is 15000 or below the
spreadsheet multiples another cell by a certain percent, putting the result in the current cell, if the first cell is between 15001 and 25000 it multiplies by another percent. This goes on for four total iterations. Can anyone help me? -- -pbell |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Else Formula for Excel Worksheet
A1 is the cell we are testing. B1 is the cell we are multiplying.
You don't need an IF statement for the last percentage assuming you want any other number other than the ones you've defined previously to trigger the next percentage. =if(a1<15000,B1*15%,if(and(a1=15001,A1<=25000),b1 *20%,if(and(a1=25001,a1<=35000),b1*25%,b1*30%))) -- JNW "pabell" wrote: I need a formula that evaluates a cell and if that cell is 15000 or below the spreadsheet multiples another cell by a certain percent, putting the result in the current cell, if the first cell is between 15001 and 25000 it multiplies by another percent. This goes on for four total iterations. Can anyone help me? -- -pbell |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Else Formula for Excel Worksheet
You don't give many details but try something like:
=G6*LOOKUP(F6,{0,15000,25000,35000,45000},{0.05,0. 1,0.15,0.2,0.25}) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pabell" wrote in message ... I need a formula that evaluates a cell and if that cell is 15000 or below the spreadsheet multiples another cell by a certain percent, putting the result in the current cell, if the first cell is between 15001 and 25000 it multiplies by another percent. This goes on for four total iterations. Can anyone help me? -- -pbell |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Else Formula for Excel Worksheet
You can make the formula slightly shorter by doing this:
=G6*LOOKUP(F6,{0,15,25,35,45}*1000,{0.05,0.1,0.15, 0.2,0.25}) "Sandy Mann" wrote: You don't give many details but try something like: =G6*LOOKUP(F6,{0,15000,25000,35000,45000},{0.05,0. 1,0.15,0.2,0.25}) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pabell" wrote in message ... I need a formula that evaluates a cell and if that cell is 15000 or below the spreadsheet multiples another cell by a certain percent, putting the result in the current cell, if the first cell is between 15001 and 25000 it multiplies by another percent. This goes on for four total iterations. Can anyone help me? -- -pbell |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Else Formula for Excel Worksheet
But you've made it less efficient by adding an unnecessary step in the
calculation process. Shorter isn't always better. http://tinyurl.com/2xby3d -- Biff Microsoft Excel MVP "Teethless mama" wrote in message ... You can make the formula slightly shorter by doing this: =G6*LOOKUP(F6,{0,15,25,35,45}*1000,{0.05,0.1,0.15, 0.2,0.25}) "Sandy Mann" wrote: You don't give many details but try something like: =G6*LOOKUP(F6,{0,15000,25000,35000,45000},{0.05,0. 1,0.15,0.2,0.25}) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pabell" wrote in message ... I need a formula that evaluates a cell and if that cell is 15000 or below the spreadsheet multiples another cell by a certain percent, putting the result in the current cell, if the first cell is between 15001 and 25000 it multiplies by another percent. This goes on for four total iterations. Can anyone help me? -- -pbell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing formula for excel worksheet | New Users to Excel | |||
How do I lock a formula in a cell in an Excel worksheet? | Excel Discussion (Misc queries) | |||
Excel Formula/Worksheet maybe Macro Question | Excel Worksheet Functions | |||
How do I make formula in Excel from other worksheet? | Excel Worksheet Functions | |||
Display excel formula on worksheet | Excel Worksheet Functions |