I noticed something a bit weird about how Excel handles powers. For example, the expression isn’t ambiguous at all. But in Excel, you get something every different if you enter EXP(-(a2+1)^2/8) or if you enter EXP(-((a2+1)^2/8). Evidently, EXP(-(a2+1)^2/8) is read as EXP((-(a2+1))^2/8) which strikes me as strange.
April 15, 2014
Excel’s weird way of dealing with powers
Leave a Comment »
No comments yet.