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.