I need to set a limit on a cell, whereas it will limit the amount from one
formula and add the value to the set limit from another cell. For instance I
want the maximum input from cell "A" to be limited to a certain quantity, yet
allow the value from cell "B" to be added to the maximum quantiy from cell
"A" being displayed in cell "C". Example, input from cell "A" call it "A1"
whereas A1 can = 0 through 1000, and cell "B" call it "A2" can = 0 through
50, and cell "C" being "A3" is the sum of "A1" and "A2", I need to limit the
input from "A1*5" to 500 but I also need to add the total in "A2" to "A3"
with no restrictions whereas "A3" can only accept a maximum amount from "A1",
but accept any number from "A2".
So if "A1" equals 750 the maximum return to "A3" of (A1*5) cannot exceed
500, while the sum of (A1*5)+A2 can be greater than 500.