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