Quote:
Originally Posted by LeeLobb
I have a formula set to multiply a rate by a quantity, I then need to cap the
total at 200
example:
42 people x 86 minutes x $0.05 = $180.60
but I need the total to cap at $200 when a different amount of people is
entered and takes it above $200
make sense?
|
I have a similar problem but want the result to be constrained between two numbers . I can do the bottom and top constraints individually but cannot figure out how to combine the formulas. The formulas i have are...
Bottom =MAX(350,(A1*0.15%))
Top =MIN(1500,(A1*0.15%))
essentailly i want the result to be constrained between 350 and 1500 when multiplying cell A1 by 0.15%.
Any suggestions?
thanks in advance