Re: Help writing a formula

One way
=B3*3%+((B3-40001)*(B3>40000)*3%)+((B3-50001)*(B3>50000)*2%)

--
Regards

Roger Govier


"Adam" <adrake@xxxxxxxxxxxxx> wrote in message
news:DB4993A8-29BC-47E4-87DD-601F9B2B9CDC@xxxxxxxxxxxxxxxx
> 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(B3>40000000,0.03*40000000,IF(50000000>B3>40000000,(B3-40000000)*0.06,if(B3>50000000,10000000*0.06,IF(B3>50000000,(B3-50000000)*0.08,0)),1200000,IF(B3<40000000,0.03*B3,if(B3>40000000,0.03*40000000,IF(50000000>B3>40000000,(B3-40000000)*0.06,if(B3>50000000,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,200>formula, 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))


.