Hi

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:

=IF(C4<=25,0,IF(C4>100,100,IF(C4<=500000000,25,IF(C4<=100,50)))

Thanks!

## Bookmarks