Using currency with multiplying formulas

  • Resolved conguyuk83

    (@conguyuk83)


    9 years, 2 months ago

    hi,

    I’m trying to use the pound sign (£) as a currency for adding up total amounts in a several columns in the spreadsheet with a total formula, however when I use the formula with a pound sign, it gets rejected. the formula I’m using is =B4+C4+D4+E4+F4 for monetary amounts in the colums. this works fine, until I add a pound sign in front of the amount, and when viewing the spreadsheet, I get the following error: !ERROR! E4 does not contain a number or expression.

    How can I add up the rows whilst still using the pound sign as a curreny, and having it displayed on the form?

    Thanks

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    9 years, 2 months ago

    Hi,

    thanks for your question, and sorry for the trouble.

    This is not that easy, I’m afraid, as TablePress can not use text/strings or currency values in formulas. It can only use plain numbers there.

    However, there’s a workaround for your task: You could add a hidden column to your table that only holds the plain number values of your currencies. Then, your formula will work fine.
    However, we will not display the information from that column, but instead make use of a special formula syntax in the actual column, like
    =${B1}
    This allows taking the plain number values (or formula results) and show them in the adjacent cell, but with a currency symbol. Please see the explanation in the middle of https://tablepress.org/tablepress-features-formulas/ for details on this syntax.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Using currency with multiplying formulas’ is closed to new replies.