Thread: Lehman formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dr. Mark W. Lee Dr. Mark W. Lee is offline
external usenet poster
Posts: 1
Default Lehman formula

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,


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.