Tier Pricing Help

gzat · Feb 14th 2020

Hi, Below is a grid I am trying to create a calculation fo Minimun AUM Maximum AUM Fee $0.00 $750,000.00 0.01000% $750,000.00 $1,500,000.00 0.00500% $1,500,001.00 $3,000,000.00 0.00250% $3,000,001.00 $1,000,000,000.00 0.00125% My f My forumla is =SUMPRODUCT(--(G8>{0,750000,1500000,3000000}),G8-{0,750000,1500000,3000000},{0.0001,0.00005,0.000025,0.0000125})ormula The end result is off, please help thanks!

**royUK** · Feb 15th 2020

To help us provide an answer please attach a small workbook showing a sample of your data and what you want the result to be

gzat · Feb 18th 2020

Hi,

Thanks for offering to help. I attached a sample with the total AUM on top

gzat · Feb 18th 2020

Sorry this is the amt ...

$11,103.53

Tier Pricing Help

Participate now!

Share

Tags