# 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

- Created by: Abraham Smith
- Created on: 07-05-13 13:47

## 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")

## Similar ICT resources:

Teacher recommended

Teacher recommended

Teacher recommended

## Comments

No comments have yet been made