IF Functions
=IF(B2>=75,"Distinction",IF(B2>=50,"Pass","Fail")) If B2 equals 83 then the answer can be Distinction or Pass, however the priority always goes to the first statement, explaining why anything which isn't Pass or Distinction is Fail.
=IF(B2>D2,"Home",IF(B2<D2,"Away",IF(B2=D2,"Draw"))), so if Team 1 (B2) scores one and Team 2 (D2) scores two the answer is Away.
- Created by: Thomas Gamble
- Created on: 09-04-13 12:00
Comments
No comments have yet been made