• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Ask AI
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

20% off ACCA & CIMA Books

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

How to deal with negative numbers on a spreadsheet

Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA TX-UK Exams › How to deal with negative numbers on a spreadsheet

  • This topic has 3 replies, 3 voices, and was last updated 2 years ago by JillyB.
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • November 15, 2022 at 2:50 pm #671507
    myacca1990
    Participant
    • Topics: 153
    • Replies: 164
    • ☆☆☆

    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.

    November 17, 2022 at 8:57 am #671694
    poojakumar
    Participant
    • Topics: 6
    • Replies: 4
    • ☆

    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

    November 18, 2022 at 12:03 am #671771
    myacca1990
    Participant
    • Topics: 153
    • Replies: 164
    • ☆☆☆

    It worked like a charm ?
    Thanks @poojakumar

    November 24, 2022 at 11:15 am #672414
    JillyB
    Keymaster
    • Topics: 0
    • Replies: 899
    • ☆☆☆☆

    Well done

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.
Log In

Primary Sidebar

Donate
If you have benefited from our materials, please donate

ACCA News:

ACCA My Exam Performance for non-variant

Applied Skills exams is available NOW

ACCA Options:  “Read the Mind of the Marker” articles

Subscribe to ACCA’s Student Accountant Direct

ACCA CBE 2025 Exams

How was your exam, and what was the exam result?

BT CBE exam was.. | MA CBE exam was..
FA CBE exam was.. | LW CBE exam was..

Donate

If you have benefited from OpenTuition please donate.

PQ Magazine

Latest Comments

  • hhys on PM Chapter 4 Questions Environmental Management Accounting
  • singhjyoti on Conceptual Framework – ACCA SBR lecture
  • John Moffat on Time Series Analysis – ACCA Management Accounting (MA)
  • azubair on Time Series Analysis – ACCA Management Accounting (MA)
  • Gowri7 on Relevant cash flows for DCF Working capital (examples 2 and 3) – ACCA Financial Management (FM)

Copyright © 2025 · Support · Contact · Advertising · OpenLicense · About · Sitemap · Comments · Log in