Be careful when using Excel
"Antonio Vernucci" wrote in
:
I think this message can be of interest for those using Excel for
antenna calculations.
Write in one cell: =(-A1^2 + 8) Note: the exponent of A1 is 2 (and
not 2+8=10) because Excel performs squaring before summing
Write in another cell: =(8 - A1^2)
Do you realise that the '-' in both expressions are quite different in
meaning, one is a unary negation operator, the other is the binary
subract operator.
No magic there, force the - to be a unary operator, and it behaves
consistently, eg 8+-2^2 gives 12.
They look pretty much the same
Not to a programmer!
Owen
But give A1 any non-zero value and see what happen.
73
Tony I0JX
Rome, Italy
|