| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Help writing a formula
Hello,
I'm trying to write the following lease rent formula in a cell: If(1,200,000((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)),1,200,000,((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)) |
|
#2
|
|||
|
|||
|
I dont understand what you are actually trying to do,but here goes.....
if(A3<=40000,1200000*0.3,if(a3<=50000,1200000*.06, 1200000*.08)) if A3 is equal to or less than 40,000,then 1,200,000 times 3 percent..etc etc etc -- paul remove nospam for email addy! "Adam" wrote: Hello, I'm trying to write the following lease rent formula in a cell: If(1,200,000((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)),1,200,000,((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)) |
|
#3
|
|||
|
|||
|
What I really need to know is how to write an "up to value", a between, and
greater than formula. Because I'm trying to times 3% to a value up to 40,000, then 6% to a value between 40,000 and 50,000, then 8% to anything over 50,000. For example, lets say I make 65,000 in a year (number in Cell A3). Then the formula would be 3% times the first 40,000 in cell A3, 6% times the difference of (50,000-40,000) in cell A3, and 8% times 65,000 - 50,000 in cell A3. Finally, once that formula is written, then the answer is the greater of 1,200 or the formula. If(1,200formula, 1,200, formula). "paul" wrote: I dont understand what you are actually trying to do,but here goes..... if(A3<=40000,1200000*0.3,if(a3<=50000,1200000*.06, 1200000*.08)) if A3 is equal to or less than 40,000,then 1,200,000 times 3 percent..etc etc etc -- paul remove nospam for email addy! "Adam" wrote: Hello, I'm trying to write the following lease rent formula in a cell: If(1,200,000((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)),1,200,000,((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)) |
|
#4
|
|||
|
|||
|
I've started writing it. It should look like this but I'm getting an error.
IF(1200000(IF(B3<40000000,0.03*B3,if(B340000000, 0.03*40000000,IF(50000000B340000000,(B3-40000000)*0.06,if(B350000000,10000000*0.06,IF(B3 50000000,(B3-50000000)*0.08,0)),1200000,IF(B3<40000000,0.03*B3, if(B340000000,0.03*40000000,IF(50000000B3400000 00,(B3-40000000)*0.06,if(B350000000,10000000*0.06,IF(B3 50000000,(B3-50000000)*0.08,0)) "Adam" wrote: What I really need to know is how to write an "up to value", a between, and greater than formula. Because I'm trying to times 3% to a value up to 40,000, then 6% to a value between 40,000 and 50,000, then 8% to anything over 50,000. For example, lets say I make 65,000 in a year (number in Cell A3). Then the formula would be 3% times the first 40,000 in cell A3, 6% times the difference of (50,000-40,000) in cell A3, and 8% times 65,000 - 50,000 in cell A3. Finally, once that formula is written, then the answer is the greater of 1,200 or the formula. If(1,200formula, 1,200, formula). "paul" wrote: I dont understand what you are actually trying to do,but here goes..... if(A3<=40000,1200000*0.3,if(a3<=50000,1200000*.06, 1200000*.08)) if A3 is equal to or less than 40,000,then 1,200,000 times 3 percent..etc etc etc -- paul remove nospam for email addy! "Adam" wrote: Hello, I'm trying to write the following lease rent formula in a cell: If(1,200,000((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)),1,200,000,((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)) |
|
#5
|
|||
|
|||
|
One way
=B3*3%+((B3-40001)*(B340000)*3%)+((B3-50001)*(B350000)*2%) -- Regards Roger Govier "Adam" wrote in message ... I've started writing it. It should look like this but I'm getting an error. IF(1200000(IF(B3<40000000,0.03*B3,if(B340000000, 0.03*40000000,IF(50000000B340000000,(B3-40000000)*0.06,if(B350000000,10000000*0.06,IF(B3 50000000,(B3-50000000)*0.08,0)),1200000,IF(B3<40000000,0.03*B3, if(B340000000,0.03*40000000,IF(50000000B3400000 00,(B3-40000000)*0.06,if(B350000000,10000000*0.06,IF(B3 50000000,(B3-50000000)*0.08,0)) "Adam" wrote: What I really need to know is how to write an "up to value", a between, and greater than formula. Because I'm trying to times 3% to a value up to 40,000, then 6% to a value between 40,000 and 50,000, then 8% to anything over 50,000. For example, lets say I make 65,000 in a year (number in Cell A3). Then the formula would be 3% times the first 40,000 in cell A3, 6% times the difference of (50,000-40,000) in cell A3, and 8% times 65,000 - 50,000 in cell A3. Finally, once that formula is written, then the answer is the greater of 1,200 or the formula. If(1,200formula, 1,200, formula). "paul" wrote: I dont understand what you are actually trying to do,but here goes..... if(A3<=40000,1200000*0.3,if(a3<=50000,1200000*.06, 1200000*.08)) if A3 is equal to or less than 40,000,then 1,200,000 times 3 percent..etc etc etc -- paul remove nospam for email addy! "Adam" wrote: Hello, I'm trying to write the following lease rent formula in a cell: If(1,200,000((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)),1,200,000,((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)) |
|
#6
|
|||
|
|||
|
I believe this could be one option:
=MAX(1200, 0.06*A1-1200, 0.08*A1-2200) HTH -- Dana DeLouis Win XP & Office 2003 "Adam" wrote in message ... I've started writing it. It should look like this but I'm getting an error. IF(1200000(IF(B3<40000000,0.03*B3,if(B340000000, 0.03*40000000,IF(50000000B340000000,(B3-40000000)*0.06,if(B350000000,10000000*0.06,IF(B3 50000000,(B3-50000000)*0.08,0)),1200000,IF(B3<40000000,0.03*B3, if(B340000000,0.03*40000000,IF(50000000B3400000 00,(B3-40000000)*0.06,if(B350000000,10000000*0.06,IF(B3 50000000,(B3-50000000)*0.08,0)) "Adam" wrote: What I really need to know is how to write an "up to value", a between, and greater than formula. Because I'm trying to times 3% to a value up to 40,000, then 6% to a value between 40,000 and 50,000, then 8% to anything over 50,000. For example, lets say I make 65,000 in a year (number in Cell A3). Then the formula would be 3% times the first 40,000 in cell A3, 6% times the difference of (50,000-40,000) in cell A3, and 8% times 65,000 - 50,000 in cell A3. Finally, once that formula is written, then the answer is the greater of 1,200 or the formula. If(1,200formula, 1,200, formula). "paul" wrote: I dont understand what you are actually trying to do,but here goes..... if(A3<=40000,1200000*0.3,if(a3<=50000,1200000*.06, 1200000*.08)) if A3 is equal to or less than 40,000,then 1,200,000 times 3 percent..etc etc etc -- paul remove nospam for email addy! "Adam" wrote: Hello, I'm trying to write the following lease rent formula in a cell: If(1,200,000((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)),1,200,000,((.03*Cell A3 up to $40,000,000)+(.06*Cell A3 between $40,000,000 and $50,000,000)+(.08*Cell A3 any value greater than $50,000,000)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Help with array formula | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Hybrid Mode
