In this section there is a problem
IF(S26<$B26,"low",IF(S26=$B26,"

so if F26<B26 then "Low"
The next if statement is always true. If we got here then S26 must be = B26
since it can not be less than...
--
HTH...

Jim Thomlinson


"Petros" wrote:

=IF(S26$C26,"high",IF(S26<$B26,"low",IF(S26=$B26 ,"normal",IF(S26<=$C26,"normal",IF(S26="0"+S26,"no test")))))

This IF formula string does not allow the last function to operate??? Why??