-1^2

31/07/2007 - 17:16 por Farnesio | Informe spam
It seems that in Excel the expression -1^2 is equal to 1 (or similar with
any expression having a minus sign before, and and exponent after; the minus
sign is included in the expression). It is different for instance in Visual
Basic 6.0 or 2005, where -1^2 = -1, or in the other programming languages I
remember. I presume it is also different in the Basic available into Excel
via Alt-F11. It looks like an inconsistency. ¿Is there any option in Excel to
modify this? Regards.
 

Leer las respuestas

#1 Xavier Budet Graco
31/07/2007 - 19:20 | Informe spam
Hola Farnesio, en Matemáticas -1^2 = -1 * -1 = 1.

Saludos,

Xavier

Quitar MAC para contestar. Gracias.

"Farnesio" escribió en el mensaje news:
It seems that in Excel the expression -1^2 is equal to 1 (or similar with
any expression having a minus sign before, and and exponent after; the minus
sign is included in the expression). It is different for instance in Visual
Basic 6.0 or 2005, where -1^2 = -1, or in the other programming languages I
remember. I presume it is also different in the Basic available into Excel
via Alt-F11. It looks like an inconsistency. ¿Is there any option in Excel to
modify this? Regards.

Preguntas similares