Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


when we try to calculate the cube root of -27 (using the formula = POWER
(A1, 1/3) -3 Calc should give us but gives us the message # VALUE!
I solved the problem by modifying the formula as follows:
=-POWER (-A1, 1/3) and this modification Calc can give us the correct
answer.
Well I think to include this modification in Cal would take a decision
block, suppose that the entries are "numbers, index". The terms of the
decision would be:
if (num <0 & 1/index% 2 = 1)
The first one test if num is a negative number, the second one trys if
index is an odd number, yet if an integer. If true both conditions would be
used if the proposed amendment and was not used the normal function.
If this helps please let me know. I hope not look like a fool. If Cal can
do the calculation differently let me know as it does, thanks for
everything.

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.