• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Broken IF formula

Marcos Lee

New Member
Has anyone any idea why this formula doesn't work!?


=IF(B4>89,E7,IF(B4<=89,E6,IF(B4<=79,E5)))


It looks at a value in B4 and then should represent what level the score is. from this table.


Level Score

0 69-0

1 79-70

2 89-80

3 90+


Any help appreciated!!
 
Top