Forum Discussion
IF function issues
I'm looking for help creating a formula that will populate up to a certain amount, then move anything over that dollar amount to the next "bucket" up to a certain amount, and anything above that to t...
I wrote the attached file specifically for a dynamic array version of Excel which would allow the arrays to resize without user intervention. Since it is unlikely that many potential users with have dynamic array code, I have changed it to CSE arrays.
I have used matrix multiplication to accumulate the cumulative fees. After picking the lower value from every pair of cumulative fee and the upper limit of a fee band, incremental values are returned by differencing adjacent values, again using matrix multiplication (using the inverse of the matrices that accumulated the fees). This is not for the faint-hearted!
Sadly CSE is clunky and the solution will be a poor shadow of the dynamic array solution.