If formula with a upper and lower value limits

[elcasey125]

The values in F4:F14 are changed depending on the value in F2. The rows in green have a fixed value. The row in yellow has a lower limit (170)and upper limit (195). I cannot get a formula in F14 to perform this function. Thank You in advance.

[Ron Coderre]

Using your posted workbook....
Try tnis

Please Login or Register  to view this content.

Copy that formula up as far as you need.

Does that help?

[martindwilson]

for future reference you have not constructed the if correctly
=IF(D9*F2<=170,170,IF(D9*F2>=195,195,D9*F2))

[elcasey125]

Thanks Ron, Problem solved.