20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for September 2025 exams.
Get your discount code >>

Variance Calculations in spreadsheet to be shown always as a positive number?

This topic has 1 reply, 2 voices, and was last updated 4 years ago by John Moffat.

Viewing 2 posts - 1 through 2 (of 2 total)

Author
Posts
June 6, 2021 at 3:12 am #623347
Abhinav1608
Participant
- Topics: 4
- Replies: 4
So, after i put in the formula and get an adverse variance, does it matter if it is a positive number or negative? I will show “A” or “F” Besides the calculation.
This is because in all the solutions, the final answer is always positive with A or F besides it.
June 6, 2021 at 9:51 am #623389
John Moffat
Keymaster
- Topics: 57
- Replies: 54696
It does not matter whether it shows as positive or negative, provided that you have put the correct A or F by the side of it 🙂
Author
Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.