# 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 150K or more?

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

## 2. For Sprints

• =IF('Calculation'!J51<=5%,"Yes","No")
• =IF('Climb Calculation'!J51<=5%)
• =IF('Climb Clculatin'!J51=5%,"Yes","No")
• =IF('Climb 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")

## 3. For 1Cat 1Climb

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

## 4. For no more than 200K

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

## 5. For 2 Category 1 or 2 Climbs

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