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.