Tablepress 1.1 and new math functions

Hi,

thanks for your question.

I’m still working on documenting all the math functions, but here’s a quick list of all the functions that are available (old and new):

'sin','sinh','arcsin','asin','arcsinh','asinh',
'cos','cosh','arccos','acos','arccosh','acosh',
'tan','tanh','arctan','atan','arctanh','atanh',
'sqrt','abs','ln','log','exp','floor','ceil'
'average', 'mean',
'median', 'mode', 'range',
'max', 'min',
'mod', 'pi', 'power',
'round',
'number_format', 'number_format_eu',
'sum', 'product',
'rand_int', 'rand_float',
'arctan2',  'atan2',
'if'

Additionally you can now put text around the result of formula, like this:

=The sum of the column is {SUM(A2:A5)}.

or

=Price: {A3*A5} EUR

Regards,
Tobias

Hi,

you are very welcome! 🙂 Nice to hear that you like it!

Best wishes,
Tobias

Hi Daniele,

thanks for your question!

For the if-formula, the cell references must be uppercase. Also, for a “equal” comparision, you’ll need to use just one “=”. Finally, the parameter delimiter is the comma ,. So, your formula needs to be changed to

=if(A2=0,B2,C2)

Regards,
Tobias

Hi,

no problem, you are very welcome! 🙂

Best wishes,
Tobias

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

Hi,

yes, this particular case won’t work, unfortunately. The problem here is that the parameters of the if function are evaluated before the actual if function. So, F2/C2 will always be calculated (and result in an error if C2 is zero). And as that error is raised, the if does not help here 🙁

As a workaround, you could maybe try this:

=if(C2=0,0,C3/if(C2=0,1,C2))

In that, the second if will just determine the denominator of the quotient. If C2 is non-zero, that will be used, but if it is zero, 1 will be used. This does not effect the result, it just makes sure that the actual division (regardless of whether the result will be used or not) does not return an error.

Regards,
Tobias

Hi,

great! That’s good to hear 🙂

Best wishes,
Tobias