Math functions with text

  • Resolved p3t3rr

    (@p3t3rr)


    5 years, 11 months ago

    Hi

    I need to apply math functions in order to calculate values of some cells automatically. However, it doesn´t work because some cells include more than just pure number (e.g dollar sign).

    How can I make the funtions work even if a referenced cell includes a $ sign or other text?

    Thank you for your help,

    p3t3rr

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    5 years, 11 months ago

    Hi,

    thanks for your question, and sorry for the trouble.

    The math functions only accept numbers (or other formulas), but no text or characters.
    The trick therefore is to have them work on numbers only and then add the text (like $) afterwards. For, this you could maintain two columns of data, one with numbers and formulas that you however hide from the user, and another one that simply takes the calculated value and formats it, with a formula like
    =${A4}

    Regards,
    Tobias

    Thread Starter p3t3rr

    (@p3t3rr)

    5 years, 10 months ago

    Hi Tobias,

    thank you for the answer. It definitely helps I will play around with that trick.

    Regards,
    Peter

    Plugin Author TobiasBg

    (@tobiasbg)

    5 years, 10 months ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Math functions with text’ is closed to new replies.