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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Learning to Fly 7
For-Next by a row Counting consecutive Zero in the column 4
Getting Rid of Zeros 2
Excel Worksheet Functions 5
Cell ref is it possibile to calculate / change this in a formula 3
LOOKUP 2
need to copy/paste formula w/o it changing 4
Help with a multi if then else formula. 5

Back
Top