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...
Have look at the attached file (i.e. a copy of your own with some formulae added). I assume that this does what you asked for. I chose to work with MIN and MAX functions to determine the overflow of each "bucket". I've tested it with varying quarterly fees earned and it seems to work all the time.
Riny_van_Eekelen - thank you so much. I didn't even think to use MIN MAX statements. Still learning some of the more "advanced" excel functions but this will be a great reference going forward.
Very much appreciated!!!
