I have a situation where i need 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