Unknown Logical Test in IF formula

[wilest]

I have a logcal test in an excel if statement that I don't understand, this is a nested if, which I understand completely, my trouble is with the last logical test:

IF(1.16 > B32 > E38

..................

What does this do? Does it test if 1.16 is greater than the value in B32 and then test if B32 is greater than the value in E38?

This is the entire statement:

=IF(B32<=1,1,IF(B32>1.15,E38,IF(1.16>B32>E38,E37,0)))

Help will be greatly appreciated.

 

[FormR]

Hi, it probably does not do what was intended

This "1.16 > B32" will be evaluated first to TRUE or FALSE and then that Boolean value will be compared against E38 i.e. "TRUE > E38" or "FALSE > E38".

If there is a number (or even text) in E38 then this will always result in TRUE.

Perhaps the intention was:

IF(AND(1.16 > B32, 1.16 > E38)..

..Or something similar.