# 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. 1 sprint

• =IF(COUNTIF(I12:N12,"Sprint")"Yes","No")
• =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 End")=1,"Yes","No")
• =IF(I12:N12,"Sprint")=1,"Yes","No")
1 of 6

## 2. No. of climbs

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

## 3. No. of towns not visited

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

## 4. No. of Sprints

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

## 5. All towns visited

• =COUNTIF(I15=0,"Yes","No")
• =IF(I15=0,"No")
• =IF(I15+0,"Yes","No")
• =IF(I7=0,"Yes","No")
• =IF(I15=0,"Yes","No")
• =COUNTIF(I15=0,"Yes","No")
• =COUNTIF(I15=0,"Yes","No")