View Single Post
  #7   Report Post  
Harlan Grove
 
Posts: n/a
Default

Dana DeLouis wrote...
For me, sometimes the Power function can make it a little easier to

read.
ie.
=-(16)^(1/4)
returns #NUM!
which we all know to be a "issue" with Excel. (we don't want to go

there
again :) )


Well, 'we' may not if it's a rhetorical ploy in 'our' favor.

but =-POWER(16,1/4)
returns -2 as one would expect.
Just my opinion.


However, the equivalent POWER call would be

POWER(-(16),1/4)

which would return the same #NUM! error. The equivalent operator call
for your POWER call would be

-(16^(1/4))

which returns -2. If you mean POWER eliminates some ambiguity and/or
unexpected functionality from the ^ operator due to Excel's unusual
operator precedence, then fine, but IMO it'd be more useful to learn
that

-(16)^(1/4)

is a mistake in waiting [and only FORTRAN, AFAIK, distinguishes X from
(X) when X is a single variable token or a numeric constant, and then
only in function calls] which should be rewritten as

-(16^(1/4))

That is, the whole point to using the extra set of parentheses is to
overcome Excel's unhelpful operator precedence. It should be obvious
that wrapping 16 in parentheses does nothing useful.