IF Function

  • Thread starter Thread starter Petros
  • Start date Start date
P

Petros

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

This IF formula string does not allow the last function to operate??? Why??
 
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...
 
Back
Top