Title: formulas
Last modified: August 30, 2016

---

# formulas

 *  Resolved [webitbe](https://wordpress.org/support/users/webitbe/)
 * (@webitbe)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/formulas-1/)
 * Dear Support
 * I have imported a table from excel but the formulas where not set in the imported
   table.
 * in my sample
    [http://tmp.lecomptoirdupneu.be/table/](http://tmp.lecomptoirdupneu.be/table/)
   How do I set the imput field (nombre de pièce) and the result field (nombre points)
   calculated regarding a reference field (point/piece) like in excel
 * Sample: imput “4” , reference field “5”, result “20”
 * TY
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/formulas-1/#post-6450663)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Unfortunately, formulas can not directly be imported from Excel, as they are 
   not stored as text. You will need to manually type in the formulas.
    For a list,
   please see [https://tablepress.org/tablepress-features-formulas/](https://tablepress.org/tablepress-features-formulas/)
 * Regards,
    Tobias
 *  Thread Starter [webitbe](https://wordpress.org/support/users/webitbe/)
 * (@webitbe)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/formulas-1/#post-6450671)
 * Hello
    TY for quick answer I am novice in WP
 * my test page: [http://tmp.lecomptoirdupneu.be/table/](http://tmp.lecomptoirdupneu.be/table/)
   
   How do I set, in my sample page, the field “Nombre de pièces” as an imput.
 * I would like the créate a table like this one
 * [http://www.aylin.be/que-pourrait-vous-couter-le-repassage-de-votre-manne/](http://www.aylin.be/que-pourrait-vous-couter-le-repassage-de-votre-manne/)
 * Than You
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/formulas-1/#post-6450674)
 * Hi,
 * ah, now I understand what you mean.
    Unfortunately, I have to disappoint you 
   here. Something like this is not possible with TablePress. One can not add form
   fields that are then processed with the formulas, sorry.
 * You can only add data to the table on the “Edit” screen in the admin area.
 * Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘formulas’ 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: [10 years, 9 months ago](https://wordpress.org/support/topic/formulas-1/#post-6450674)
 * Status: resolved