SOLVED

Exel Formula needed - min and max figures

Copper Contributor

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

2 Replies
best response confirmed by James_Franklin1 (Copper Contributor)
Solution

@James_Franklin1 

 

=MAX(MIN(750,E35*0.25%),0)

Amazing works like a charm! - Thanks so much Martin
1 best response

Accepted Solutions
best response confirmed by James_Franklin1 (Copper Contributor)
Solution

@James_Franklin1 

 

=MAX(MIN(750,E35*0.25%),0)

View solution in original post