NetAssets BPS
1,000,000,000 1.00
2,000,000,000 2.00
3,000,000,000 2.75
4,000,000,000 3.50
5,000,000,000 4.25
6,000,000,000 5.00
7,000,000,000 5.75
8,000,000,000 6.50
9,000,000,000 7.25
10,000,000,000 8.00
11,000,000,000 8.25
I believe you're right...the deductions are cumulative. thanks for catching that.Mornin', Ron,
I think ...*({1,-0.25,-0.25}))
I think this does what you want...
With
A1: a number
This regular formula calculates the number of bps (whatever that is) based on your rules
B1: =SUM((A2/10^9>{0,2,10})*(A2/10^9-{0,2,10})*({1,-0.25,-0.5}))
These are some sample values and results
Code:NetAssets BPS 1,000,000,000 1.00 2,000,000,000 2.00 3,000,000,000 2.75 4,000,000,000 3.50 5,000,000,000 4.25 6,000,000,000 5.00 7,000,000,000 5.75 8,000,000,000 6.50 9,000,000,000 7.25 10,000,000,000 8.00 11,000,000,000 8.25
Is that something you can work with?
=2000000000*0.0001/366*31 =
<colgroup><col></colgroup><tbody> </tbody> |
=(2000000000*0.0001/366*31)+(8000000000*0.000075/366*31) =
<colgroup><col></colgroup><tbody> </tbody> |
=(2000000000*0.0001/366*31)+(8000000000*0.000075/366*31)+(5000000000*0.00005/366*31) =
<colgroup><col></colgroup><tbody> </tbody> Does that help explain my end goal? |
=IF(B4>10000000000,((B4-10000000000)*0.00005/366*C4)+(8000000000*0.000075/366*C4)+(2000000000*0.0001/366*C4),IF(B4>2000000000,((B4-2000000000)*0.000075/366*C4)+(2000000000*0.0001/366*C4),B4*0.0001/366*C4)) It's not very efficient, but it works. Thanks guys |