The answer you're getting is correct. When you instruct 3^-3, then you're instructing to devide. So it's 3/3=1/3=0,037
If you want the outcome to be a negative value of -27 then you must instruct -3^3. Arnold Huzen > > van: Andis Lazdinsh <[EMAIL PROTECTED]> > datum: 2007/01/29 Mon AM 11:15:39 CET > aan: users@openoffice.org > onderwerp: Re: [users] Extended SQRT function in Calc > > Thank you for suggestion, but this doesn't work. > For instance, if I write 27^-3 or A2^-B2 (A2=27 and B2=3), I receive > 0,0000508..., but should be 3 (3x3=9x3=27). > > I found name of function I need. In Qualculate it's called nth root and > multiple root. > > So, any other recommendations? > > Andis > > > For instance > > Andi Permadi wrote: > > Just change the x & y with Cell Address > > You have value of X in A2 > > and value of Y in B2 > > for the x^-y result just write = A2^-B2 > > it will result the value You need. > > > > On 29/01/07, Andis Lazdinsh <[EMAIL PROTECTED]> wrote: > >> Hello! > >> > >> I need to calculate x ordinal square root in calc. I'm not sure, is this > >> translation to English is right, but the formula could be =x^-y (this > >> formula results in mistakeous number). I know this can be calculated > >> easily with mathcad, but I think it should be possible to do this with > >> calc, too. > >> > >> Any suggestions, how to do this calculation? > >> > >> Andis > >> > >> -- > >> LVMI "SILAVA" > >> Riga street 111 > >> Salaspils, LV-2169 > >> > >> Phone: +37126595586 > >> Fax: +3717901359 > >> E-mail: [EMAIL PROTECTED] > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > > > > > > ------------------------------------------------------------------------ > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
