I'm new to the forum and would really appreciate some help with working out a formula for tiered values. Specifically, I have two accounts that have different tiered values and what I need is when a value is entered for account A, it uses the tiers for this account and the residual moves to Account B and uses the appropriate tier value. It's difficult to explain this in words so I've attached an excel sheet.
I realized how convoluted the thread looked after posting so I've attached an excel spreadsheet with scenarios and explanation at each tier.
This is just three scenarios but the formula’s need to cover all possibilities when a value is entered for Account A and B. I’ve been trying to work on this for a week and can’t nail it down to a formula for each tier. Hoping someone here can solve this mystery!
Thanks in advance!
Bookmarks