Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Adam
 
Posts: n/a
Default 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   Report Post  
paul
 
Posts: n/a
Default

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   Report Post  
Adam
 
Posts: n/a
Default

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   Report Post  
Adam
 
Posts: n/a
Default

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   Report Post  
Roger Govier
 
Posts: n/a
Default

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   Report Post  
Dana DeLouis
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM
Help with array formula Excel Worksheet Functions 2 January 20th 05 05:17 PM
Cell shows formula and not the result of the formula. stumpy1220 Excel Worksheet Functions 2 January 14th 05 06:11 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 04:13 PM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"