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.

?

IF Functions part 1

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

1 of 1

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »