Nested IF Statement Not Working

[rlc]

I am having issues with the following if statement. E68 is a calculated result

=IF(E68<1.01,1.01,E68), IF(E68>=1.04,1.04,E68)

Essentially it is <1%=1% or >4%=4% (a minimum and a maximum)
Thanks for any assistance you can provide.

 

[Jonmo1]

Try

=IF(E68<1.01,1.01,IF(E68>=1.04,1.04,E68))

 

[Aladin Akyurek]

I am having issues with the following if statement. E68 is a calculated result

=IF(E68<1.01,1.01,E68), IF(E68>=1.04,1.04,E68)

Essentially it is <1%=1% or >4%=4% (a minimum and a maximum)
Thanks for any assistance you can provide.

Would you try to state the problem you have in words instead of a formula?

 

[mashhood]

try this

=if(e68>=1.04,1.04,if(e68>1.01,e68,1.01))

 

[mikerickson]

Try
=MIN(MAX(E68, 1.01), 1.04)

 

[rlc]

Thanks everyone I used JonMo1's solution. Aladin thanks for the advice I will work presenting the problem in better format in future. Thanks again

 

[Jonmo1]

Glad to help, thanks for the feedback.