if you put -1 (A1) in one cell and .05 (a2) in another

=A1^A2

raises an error as well.

=-1^0.5 raises an error as well

---------------------------------------

In a worksheet, the order of operations is different:

: (colon)
(single space)

, (comma)
Reference operators
- Negation (as in -1)
% Percent
^ Exponentiation
* and / Multiplication and division
+ and - Addition and subtraction
& Connects two strings of text (concatenation)
= < <= = < Comparison


--
Regards,
Tom Ogilvy


"PatFinegan " wrote in message
...
Thanks, Nick, for the simple workaround. Strange discrepency between
Excel and VBA, though.


---
Message posted from http://www.ExcelForum.com/