Excel Problem

System
System Posts: 100,534 🤖 Admin 🤖
edited June 18 in AAT student discussion
I am currently doing an assigment that requires me to link TP&L spreadsheet with an ETB spreadsheet. The credit figures on the ETB are negatives but I need them to be positives on the TP & L. Can anyone explain how I do this please?

Comments

  • System
    System Posts: 100,534 🤖 Admin 🤖
    Excel Problem

    In the tp and l cell that you need to put a figure in type =- (equals minus) and then the appropriate cell in the etb and it should put it in as a positive.<BR><BR>You will need to do that for each balance but then if they get changed the etb will change automatically.<BR><BR>Annette
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Excel Problem

    Thankyou

Categories

Privacy Policy