# 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. No. of climbs

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

## 2. 2 climbs

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

## 3. 1 sprint

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

## 4. No. of Sprints

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

## 5. No. of towns not visited

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

Report

c00l

## Similar ICT resources:

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