Brand new to the forum so i will try my best to describe the issue.
I am creating an equation based on a sliding rate scale. I want the calculation to subtract the previous units at each rate from the total units, and if that numbre is negative to give me a result of 0 and if it is positive to give me a maximum that i establish for each tier.
Example: Equation as it looks now (using numbers instead of cell reference)
=IF(((150-30-50)<0),0,(150-30-50)) obviously equals 70
The issue is that i want it to give me a response no less than 0 and no more than 50, so if 150-30-80 is above 50 it only spits out 50, and if 150-30-80 happened to be 37, it would spit out 37.
Im not sure if i need to mix in a second =IF statement or a =Max or =Min equation.
Thanks
Bookmarks