I need to calculate based on the below chart but coming up with a negative # (I understand why) but can't figure out how to get an additional if statement to resolve or is there a better way to calculate
<tbody>
</tbody>
<colgroup><col><col span="2"><col><col></colgroup><tbody></tbody>
Fund Balance | $750,000 | ||||
Up to | $499,999 | 2.25% | =IF(J27>500000,((500000*K29)/12),(J27*K29/12)) | 937.50 | |
From | $500,000 | $999,999 | 1.97% | =IF(J27>999999,((500000*K30)/12),((J27-500000)*K30/12)) | 410.42 |
From | $1,000,000 | $2,499,999 | 1.69% | =IF(J27>2499999,((1499999*K31)/12),((J27-999999)*K31/12)) | -352.08 |
Over | $2,500,000 | 1.41% | =IF(J27<2500000,0,(J27-2500000)*K32) | 0 | |
<tbody>
</tbody>
<colgroup><col><col span="2"><col><col></colgroup><tbody></tbody>