I need help with a piecewise function in excel using =IF() statements
the value is 0 if x<=25, 25 if 25<x<=500, 50 if 50<x<=100, and 100 if x>100
The trick is that each value may only be given out once per set of X's and must stack if not present prior to that value
if you have x = 26,27,101, the values should be 25,0,150
or x = 15,16,101 the values would be 0,0,175
Any ideas on how to incorporate that into an IF statement?
I have excel 2007, not 2003
This is what I have so far, but it doesn't incorporate the fact that you can't have more than one 25 used, one 50 used, and one 100 used: