I must be missing something here. I need to calculate fees based on average net assets
First $25 bil is 20 bps (0.00002)
Next $25 bil is 15 bps (0.000015)
Next $25 bil is 10 bps (0.00001)
> $75 bil is 5 bps (0.000005)
I was able to get to the second tier with the formula working:
=IF(B14<25000000000,B14*0.00002/366*C14,IF(AND(B14>25000000001,B14<50000000000),25000000000*0.00002/366*C14+(B14-25000000000)*0.000015/366*C14))
But I get an error at the third tier
=IF(B14<25000000000,B14*0.00002/366*C14,IF(AND(B14>25000000001,B14<50000000000),25000000000*0.00002/366*C14+(B14-25000000000)*0.000015/366*C14)),IF(AND(B14>50000000001,B14<75000000000),25000000000*0.00002/366*C14+25000000000*.00002/366*c14+(B14-50000000000)*0.00001/366*C14))
I'm missing something
First $25 bil is 20 bps (0.00002)
Next $25 bil is 15 bps (0.000015)
Next $25 bil is 10 bps (0.00001)
> $75 bil is 5 bps (0.000005)
I was able to get to the second tier with the formula working:
=IF(B14<25000000000,B14*0.00002/366*C14,IF(AND(B14>25000000001,B14<50000000000),25000000000*0.00002/366*C14+(B14-25000000000)*0.000015/366*C14))
But I get an error at the third tier
=IF(B14<25000000000,B14*0.00002/366*C14,IF(AND(B14>25000000001,B14<50000000000),25000000000*0.00002/366*C14+(B14-25000000000)*0.000015/366*C14)),IF(AND(B14>50000000001,B14<75000000000),25000000000*0.00002/366*C14+25000000000*.00002/366*c14+(B14-50000000000)*0.00001/366*C14))
I'm missing something