Skip to content

Ask the Tutor ACCA TX-UK

How to deal with negative numbers on a spreadsheet

TTahir3y ago
I've read in a examiner report that it makes easy for a marker to Mark if the negative figures are shown negative on a spreadsheet but I get the problem of adding it instead while doing subtraction because you know two negatives result in a addition on a spreadsheet.
PPooja3y ago#1
in that case, you could show both the figures as a negative amount in the spreadsheet then use the SUM formula which will add the 2 negative figures
TTahir3y ago#2
It worked like a charm ? Thanks @poojakumar
JJill3y ago#3
Well done
Sign into reply to this topic.