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