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)

?
No. of towns not visited
=COUNTIF(U28:AC28,0)
1 of 6
All towns visited
=IF(I15=0,"Yes","No")
2 of 6
No. of climbs
=COUNTIF(I7:N7,"Yes")
3 of 6
2 climbs
=IF(COUNTIF(I12:N12,"Climb")=2,"Yes","No")
4 of 6
No. of Sprints
=COUNTIF(I9:N9,"Yes")
5 of 6
1 sprint
=IF(COUNTIF(I12:N12,"Sprint")=1,"Yes","No")
6 of 6

Other cards in this set

Card 2

Front

All towns visited

Back

=IF(I15=0,"Yes","No")

Card 3

Front

No. of climbs

Back

Preview of the front of card 3

Card 4

Front

2 climbs

Back

Preview of the front of card 4

Card 5

Front

No. of Sprints

Back

Preview of the front of card 5
View more cards

Comments

Tohkadots

Report

c00l

Similar ICT resources:

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