Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Changing the sign for a linked value

Con risposta
Request Demo

I want to link a value from a Note (sign is positive) to an EBITDA calculation (sign is negative). Is there a way to change the formatting in the linked cell? 

3

Commenti

4 commenti

Data Voti
  • Jennifer C.

    I have the same question. Has anyone figured this out yet?

    0
  • Ekaterina Postow

    Yes, you have to right click on the link, link options, value formatting, then check off "use absolute value"

    0
  • Jennifer C.

    The underlying number is not negative; therefore, it is not using absolute value. Our consolidation software produces consolidated face statement numbers where the liabilities are positive. I need to flip those signs to negative for use in my cash flow workpaper.

    0
  • Mike

    Hi Jennifer,

    A little late to the party here. Sadly there's not been any new advancements here. I checked with our experts and there's no direct way to flip the sign of a value. The workarounds suggested are akin to the above, i.e. adding another column to your spreadsheet with a =0-Cell calc all the way down, and then linking those values instead.

    I am happy to share your experience and need back with our development team as we look further info this feature request. We'll keep you apprised there as well.

    In the meantime, give me a holler if you have any follow-ups. Thanks again and happy Friday!

    P.S. thanks for contributing as well, Ekaterina!

    0

Accedi per aggiungere un commento.