Help writing a formula
- From: "Adam" <adrake@xxxxxxxxxxxxx>
- Date: Mon, 1 Aug 2005 15:35:02 -0700
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))
.
- Follow-Ups:
- RE: Help writing a formula
- From: paul
- RE: Help writing a formula
- Prev by Date: How do I unlock a protected work***
- Next by Date: Re: inventory Help
- Previous by thread: How do I unlock a protected work***
- Next by thread: RE: Help writing a formula
- Index(es):