I have to calculate a fee based on the following
.006 on first 2MM
.005 on next 2MM
.004 on next 25MM
.003 on next 50MM
.002 on remaining assets
The market value will vary anywhere from 2MM to 100MM. I'd like the result in one cell.
How do I write an if statement that does this without having to write a formula for each fee break. thanks.
.006 on first 2MM
.005 on next 2MM
.004 on next 25MM
.003 on next 50MM
.002 on remaining assets
The market value will vary anywhere from 2MM to 100MM. I'd like the result in one cell.
How do I write an if statement that does this without having to write a formula for each fee break. thanks.