Combine formulas

  • Resolved kennethhede

    (@kennethhede)


    1 year ago

    I really can’t figure out how to combine these two formulas in one cell IF the cells A2 and B2 ALSO contains numbers in EU format with decimals.

    number_format_eu

    A2-B2

    Please help 😀

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

    (@tobiasbg)

    1 year ago

    Hi!

    Thanks for your post and sorry for the trouble!

    Unfortunately, that won’t work like that. For this, I recommend working with hidden rows/columns, which can then be used to separate the calculation from the display:

    In one row, hidden to the user, use “normal” cell values, without decimals, formatting, etc.

    Then, in e.g. the next row (which will be visible), only do =number_format_eu(A2) etc. to format that cell.

    Best wishes,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Combine formulas’ is closed to new replies.