Support » Plugin: TablePress » PMT Forumula

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    I don’t have plans to add more functions to the Formula parser at the moment, mainly because most of that comes from an external PHP library that I can not influence.

    I can therefore only suggest that you do those calculations in Excel directly, and then export/import the file that has the evaluated formulas.
    Or, you could find the “simple” mathematical expression behind the PMT() formula and directly use that in the table cells.

    Regards,
    Tobias

    bensencenbaugh

    (@bensencenbaugh)

    Thanks for the response. I can do the simple math behind the PMT formula, but the display comes back with multiple decimals. Is there a way to display in currency with two decimals?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    yes, that should be possible with the number_format() functions, and with a trick to add text around a formula result.
    For details, please see http://tablepress.org/tablepress-features-formulas/
    You will probably want something like

    =$ {NUMBER_FORMAT( ..., 2 )}

    where ... is your current formula.

    Regards,
    Tobias

    bensencenbaugh

    (@bensencenbaugh)

    Thank you.

    Is it possible to write a formula between two tables?

    For example, sum (A1 in table 1 to A1 in table 2)?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    that is more tricky. You would need to install two TablePress Extensions for this.
    One will will allow you to use cells from one table in another table (http://tablepress.org/extensions/table-cell-shortcode/ ), while the other (http://tablepress.org/extensions/shortcodes-before-formulas/ ) will make it possible to use that Shortcode in formulas.

    Please see http://wordpress.org/support/topic/shortcode-used-in-cell?replies=6#post-4542150 for some details on this.

    Regards,
    Tobias

    bensencenbaugh

    (@bensencenbaugh)

    I am sorry, but how do I update the shortcode? It is still showing [table id=16 /] and this field is not editable. (I know I am not doing something simple.)

    I have installed the two tablepress plugin extensions, but I am unsure about this step.

    I entered =[table-cell id=123 cell=C3 /] into a cell, but I am receiving Error illegal character.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no worries, we’ll get there 🙂

    With “updating the Shortcode”, I mean that you’ll need to edit the Shortcode that you have pasted into the content of the page that has the table. So, just go to the “Edit” screen of the page with the table and change the Shortcode there.

    Regards,
    Tobias

    Wow. I knew it would be simple. Works perfectly! Thank you so much.

    One last question. Is there any way to reduce the amount of decimal numbers to 2 like for currency?

    For example, C1 is hidden and has the formula =10/3. Then in B1 I have =${C1}. (I have it like this because I have many cells that are calculated together) The answer is displaying $3.333333333333. Do you have any ideas how to correct this?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    great to hear that the Shortcodes now work!

    For the decimals, as mentioned above, just use the NUMBER_FORMAT() or ROUND() function, like

    =$ {NUMBER_FORMAT( C1, 2 )}

    Regards,
    Tobias

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘PMT Forumula’ is closed to new replies.