Forum Discussion

James_Franklin1's avatar
James_Franklin1
Copper Contributor
May 30, 2024
Solved

Exel Formula needed - min and max figures

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

Resources