RE: Help writing a formula

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))
.

Relevant Pages

  • RE: select cell by variable name
    ... D11 and the variable is now D11 after add row. ... "Adam" wrote: ... is there any way to select a cell ... When I insert a row after I have recorded a macro, ...
    (microsoft.public.excel.misc)
  • Re: Tech: JD Deadworld mod
    ... Al, I can try to help you out, email me and I will email back my cell ... the project so things maybe a little fresher. ... Adam, also posted his work on pinball news fast and free. ...
    (rec.games.pinball)
  • RE: A conditional lookup question.
    ... "Adam" wrote: ... Them you put this formula in cell G1 in the second tab and then drag down ... The first tab is a master list with eight columns. ...
    (microsoft.public.excel.misc)
  • Re: Is there a way to... in 97
    ... > This will return the first named range that it finds. ... > in any cell. ... > "Adam Kroger ... > Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: pricing problems
    ... when you choose "wood" your first special cell shows wood ... your email addy here i will mail you a example. ... we would like it to use the next largest measurement. ...
    (microsoft.public.excel.worksheet.functions)
Loading