WordPress.org

Forums

TablePress
[resolved] PMT Forumula (10 posts)

  1. bensencenbaugh
    Member
    Posted 8 months ago #

    Is it possible to add the PMT formula? I would like to have a mortgage calculator, but this Excel formula is not working.

    http://office.microsoft.com/en-us/excel-help/pmt-HP005209215.aspx

    https://wordpress.org/plugins/tablepress/

  2. TobiasBg
    Member
    Plugin Author

    Posted 8 months ago #

    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

  3. bensencenbaugh
    Member
    Posted 8 months ago #

    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?

  4. TobiasBg
    Member
    Plugin Author

    Posted 8 months ago #

    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

  5. bensencenbaugh
    Member
    Posted 8 months ago #

    Thank you.

    Is it possible to write a formula between two tables?

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

  6. TobiasBg
    Member
    Plugin Author

    Posted 8 months ago #

    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

  7. bensencenbaugh
    Member
    Posted 8 months ago #

    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.

  8. TobiasBg
    Member
    Plugin Author

    Posted 8 months ago #

    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

  9. bensencenbaugh
    Member
    Posted 8 months ago #

    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?

  10. TobiasBg
    Member
    Plugin Author

    Posted 8 months ago #

    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

Reply

You must log in to post.

About this Plugin

About this Topic