Formula doesn’t work with € amount

Hi,

thanks for your question, and sorry for the trouble.

Sorry, that’s not directly possible. You would need to split the columns into one for the calculation (which can be marked as hidden to the user), and one for display. Then, you would for example have

=0.32*5

in cell D3, and the in the cell E3

={NUMBER_FORMAT_EU( D3, 2 )} €

Regards,
Tobias

Do you think it would be possible to update the Tablepress plug-in with this function?

Hi,

do you mean an update that adds the direct possibility to use e.g. € in formulas? No, sorry, that’s not going to happen in the foreseeable future, simply as it would be very hard to implement this, and as there are alternatives.

Regards,
Tobias

Yes, exactly.

Do you mean with alternatives putting the calculation and the “€” in seperate columns?

Could you develop it if we compensate you?

Hi,

No, I don’t really mean to put the € into a separate column. The alternative would be to split calculation and formatting/display. This would not only add more flexibility, it would also make it much easier for you to maintain the formulas and calculations. The end result would still be a perfectly-looking currency value in a single cell, with the example from above.

Another option would of course be to do all these calculations offline, e.g. in Excel, and then save the table to a CSV file (with just the formatted calculation results) which you then import into TablePress.

Unfortunately, this is not something that I could develop even with compensation, as I simply don’t see a good way to do it right now, sorry.

Regards,
Tobias

Ok, I managed to make it work!

This is what I use now:

={NUMBER_FORMAT_EU([table-cell id=655 cell=B2 /]*1.1*20, 1)}€

Thanks!

Hi,

yes, that’s a great example of using the [table-cell] Shortcode. Nice!

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!