For recurring revenue use..
=SUMPRODUCT(--(A1>{0,840000,1050000,4200000}),--(A1-{0,840000,1050000,4200000}),{0.025,0.0025,0.0025,0.005})
Add the 1% one time fees and the bonuses to the sum calculated above
For recurring revenue use..
=SUMPRODUCT(--(A1>{0,840000,1050000,4200000}),--(A1-{0,840000,1050000,4200000}),{0.025,0.0025,0.0025,0.005})
Add the 1% one time fees and the bonuses to the sum calculated above
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks