- Messages
- 21
- Reaction score
- 7
- Points
- 13
So this is how it goes. I did my paper 3 exam like 2 weeks ago. It went pretty well, can't complain. If I am not mistaken, the query I have is related to step 52. It was the spreadsheet part, the question asked about using a formula to calculate some employee pay or something, I used nested if, and all my friends did too. When I used nested if, I used like 4 absolute references and the question specified only 2 absolute references and 1 relative should be used. Even though, I just went with nested if. There is this one guy that used a vlookup and multiplied it with another value to get the same answers, and he used the same amount of absolute and relative references that was asked in the questions. Which one did you guys use and which one is the correct one? and even if nested if is wrong, how many marks will I loose?