Posts by gzat

    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!