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
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
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
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?
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
Thank you.
Is it possible to write a formula between two tables?
For example, sum (A1 in table 1 to A1 in table 2)?
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
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.
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?
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
This topic has been closed to new replies.