If I have a cell with a sum value, say 100, can I get a second cell to show a
value up to but not to exceed 50 based on the first cell? Can I then get a
third cell to show the remainder of anything over the 50 but less than say
125, based on the value of the first cell?
e.g I have 100 wigets.
the first 50 widgets cost $X;
51-125 widgets cost $Y;
over 125 widgets cost $Z
Thanks for any help

A B C D
1 100 50 50 0
2 225 50 75 100
3 45 45 0 0

For B1 Use =MIN(A1,50)
for C1 Use =MIN (A1-B1,75)
for D1 use =A1-(B1+C1)
--
If this helps, please remember to click yes.


"WaterSmith" wrote:

If I have a cell with a sum value, say 100, can I get a second cell to show a
value up to but not to exceed 50 based on the first cell? Can I then get a
third cell to show the remainder of anything over the 50 but less than say
125, based on the value of the first cell?
e.g I have 100 wigets.
the first 50 widgets cost $X;
51-125 widgets cost $Y;
over 125 widgets cost $Z
Thanks for any help