Lehman formula
I believe the formula you are looking for is this:
"=IF(RC[-1]<=1000000,RC[-1]*0.05,IF(RC[-1]<=2000000,((RC[-
1]-1000000)*0.04)+50000,IF(RC[-1]<=3000000,((RC[-1]-
2000000)*0.03)+90000,IF(RC[-1]<=4000000,((RC[-1]-3000000)
*0.02)+120000,((RC[-1]-4000000)*0.01)+140000))))"
the formula assumes the cell containing the amount is in
the cell on the left of the formula. if you copy this
formula into a cell be sure to remove the " marks around
it.
Russ
-----Original Message-----
I am looking for a way to calculate a Lehman Formula in
my spreadsheet.
Below is an example of what it is:
Thanks in advance,
Mark
Lehman Formula Fee
The finders' fee is the first check we write at the
closing
The Lehman formula fee is equal to:
5% of the first one million of value,
4% of the second million,
3% of the third million,
2% of the fourth million, and
1% of each million thereafter.
.
|