Visit and subscribe theCPAtube. Complete all HBL assignments on SLS & GC.
...
FlowChart Algorithm
Note: Always plan your algorithm on paper first before drawing on computer
How do you calculate the date of expiry of a membership?
Answer: Date of Expiry = Membership Days + Date Joined
Example:
EXAMINABLE FORMULAS
Assuming that everyone in a class scores above 50
This is how we can use the IF function to determine those who score Distinction or simply Pass.
Note
IF function
needs 3 arguments
For D10
= IF(LEFT(C10,1)="T", "Temporary",IF(LEFT(C10,1)="J","Junior","Senior"))
...
The above is a Nested If statement which summarises the following conditions
Disclaimer
NESTED IF is no longer tested from 2019 onwards.
BUT
it is a good knowledge to have.