Hi there,

I am trying to understand how I can apply BOTH a “no more than” and “no less than” answer to the same formula in exel.

For example, I know the following formula =MIN(750,E35*0.25%) will ensure the answer is no more than 750 but how do I also ensure in the same formula the answer is no less than zero?

Thanks in advance for your help

James

​Hi there, I am trying to understand how I can apply BOTH a “no more than” and “no less than” answer to the same formula in exel.For example, I know the following formula =MIN(750,E35*0.25%) will ensure the answer is no more than 750 but how do I also ensure in the same formula the answer is no less than zero?Thanks in advance for your helpJames  Read More

​