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,
thanks for the list and a good update! ??

Hi,

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

Best wishes,
Tobias

Hi Tobias!

Congratulations for your great job!

What is the syntax of the “if” formula?

Thank you in advance.

Best regards

Daniele

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

Thank you!

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 again,

I tested the if-formula with the following and it didn’t work:

=if(C2=0,0,F2/C2)

The cell C2 has, for now, a value of 0, so I’m here trying to catch up that cell that get a ‘division by zero’ error and then put only a zero value in those cases. Else it should do the normal division F2/C2.

Any tips?! ??

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,
ok, good to know.
However, that workaround will work just fine for me. Thanks! ??

Hi,

great! That’s good to hear ??

Best wishes,
Tobias