ICT Exam Formula: Working out Stages

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

HideShow resource information

1. For Sprints

  • =IF('Calculation'!J51<=5%,"Yes","No")
  • =IF('Climb Calculation'!J51<=5*,"Yes","No")
  • =IF('Climb Calculation'!I7<=5%,"Yes","No")
  • =IF('Climb Calculation'!J51<5%,"Yes","No")
  • =IF('Climb Calculation'!J51<=5%,"Yes","No")
  • =IF('Climb Calculation'!J51<=5%)
  • =IF('Climb Clculatin'!J51=5%,"Yes","No")
1 of 5

Other questions in this quiz

2. For 150K or more?

  • =IF(B30>150,"Yes","No")
  • =IF(B30>=B150,"Yes","No")
  • =IF(B30>=150)
  • =IF(B30>=150,"No")
  • =IF(E30>=15,"Yes","No")
  • =IF(B30>=150,"Yes","No")
  • =IF(C30>=150,'Yes','No')

3. For no more than 200K

  • =IF(B30<=210,"Yes","No")
  • =IF(30<=200,"Yes","No")
  • =IF(B30<=200)
  • =IF(B30<=B200,"Yes","No")
  • =IF(B30<=200,"Yes","No")
  • =IF(B30+200,"Yes","No")
  • =IF(B30<=2000,"No")

4. For 1Cat 1Climb

  • =IF('Climb Calculation'!J52=1,"Yes","No")
  • =IF('Calculation'!J52=1"Yes or No")
  • =IF(Climb Calculation?J52+1,"Yes","No")
  • =IF('Climb'!J52-I7=1,"Yes","No")
  • =IF('Climb Calculation'!J50+2=1,"Yes","No")
  • =IF('Climb Calculation'!J52=1,'Yes','No')
  • =IF('Climb Calculation'!J52=1,"No")

5. For 2 Category 1 or 2 Climbs

  • =OR('Climb Calculation'!J52=2,'Climb Calculation'!J53>=1)
  • =I(OR('Climb Calculation'!J52=2,'Climb Calculation'!J53>=1),"Yes","No")
  • =IF(OR('Climb Calculation'!J52=2,'Climb Calculation'!J53>=1),"Yes","No")
  • =IF(OR(J52=2,'Climb Calculation'!J53>=1),"Yes","No")
  • =IF('Climb Calculation'?J52=2,Climb Calculation!J53=1),"Yes","No")
  • =IF(OR'Climb Calculation'!J2,'Climb Calculation'!J3>1),"Yes","No")
  • =IF(OR('Climb Calculation'!J52=2!J53>=1),"Yes","No")

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Management and Strategies resources »