Title: Math functions with text
Last modified: May 21, 2018

---

# Math functions with text

 *  Resolved [p3t3rr](https://wordpress.org/support/users/p3t3rr/)
 * (@p3t3rr)
 * [8 years ago](https://wordpress.org/support/topic/math-functions-with-text/)
 * 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 [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years ago](https://wordpress.org/support/topic/math-functions-with-text/#post-10308396)
 * 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](https://wordpress.org/support/users/p3t3rr/)
 * (@p3t3rr)
 * [8 years ago](https://wordpress.org/support/topic/math-functions-with-text/#post-10381341)
 * Hi Tobias,
 * thank you for the answer. It definitely helps I will play around with that trick.
 * Regards,
    Peter
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years ago](https://wordpress.org/support/topic/math-functions-with-text/#post-10382774)
 * 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](https://wordpress.org/support/plugin/tablepress/reviews/)
   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.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [8 years ago](https://wordpress.org/support/topic/math-functions-with-text/#post-10382774)
 * Status: resolved