ICT Exam: Suggested formula for calculating TOUR

These are the formula that is needed to be learn by 22th May 2013 for a pass in AS ICT (Part 2)

HideShow resource information

1. 2 climbs

  • =COUNTIF(I12:N12,"Climb")=2,"Yes","No")
  • =IF(COUNTIF(N12,"Climb")=2,"Yes","No")
  • =IF(COUNT(I12:N12,"Climb")
  • =IF(COUNTIF(I12:N12,"Climb")=2,"Yes","No")
  • =IF(COUNTIF(I12:N12,"Climb")=2,"No")
  • =IF(I2:N12,"Climb")=2,"Yes","No")
  • =IF(COUNTIF(I7:N12,"Climb")=2,"Yes","No")
1 of 6

Other questions in this quiz

2. No. of Sprints

  • =COUNTIF(I9+N9,"Yes")
  • =COUNTIF(I9;N9,"Yes")
  • =COUNTIF(I9:N9,"Yes","No")
  • =COUNT(I9:N9,"No")
  • =COUNTIF(I9:N9,"Yes")
  • =IF(I9:N9,"Yes")
  • =COUNTIF(I7:N12,"Yes")

3. 1 sprint

  • =IF(COUNTIF(I12:N12,"Sprint")=1,"Yes","No")
  • =COUNTIF(I12:N12,'Sprint')=1,'Yes','No')
  • =IF(COUNT(I117:N12,"Sprint")=1,"Yes","No")
  • =IF(COUNTIF(I12:N12,"Sprint")=1,"No")
  • =IF(COUNTIF(I12:N12,"Sprint")"Yes","No")
  • =IF(COUNTIF(I12:N12,"Sprint End")=1,"Yes","No")
  • =IF(I12:N12,"Sprint")=1,"Yes","No")

4. No. of climbs

  • =IF(I7:N7,"Yes")
  • =COUNTIF(I7;N7,"Yes")
  • =COUNTIF(I7:7,"Yes")
  • =COUNTIF(I7:N7,"Yes","No")
  • =COUNTIF(I7:N117,"Yes")
  • =COUNTIF(I7:N7,"Yes")
  • =IF(I1:N7,"Yes")

5. No. of towns not visited

  • =COUNTIF(U28:AC28,0)
  • =COUNTIF(U28:C28,0)
  • =COUNTIF(U28;AC280)
  • =COUNTIF(U2:AC28,0)
  • =COUNTIF(U28:AC2,0)
  • =IF(U28:AC28,0)
  • =COUNTIF(AC28:AC28,0)

Comments

Tohkadots

Report

c00l

Similar ICT resources:

See all ICT resources »See all Data and Information resources »