Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Yornoc
-
^ Operator - raising a negative to a non integer power
...and there i was thinking i knew all there was to know about cube roots! really appreciate your time. thanks again, jges, Jon. yornoc- Yornoc
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
^ Operator - raising a negative to a non integer power
Thanks for your comments combo and voodoojon, I apologise. My original question was confusing. What I meant to say and didn't was that I am wanting to use a non integer exponent: My requirement is to calculate something like (-0.4)^(1/3). The answer is real. Excel (worksheet) calculated it...- Yornoc
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
^ Operator - raising a negative to a non integer power
Hello all, I need to calculate number^(exponent) where number is negative. Excel allows me to do this on a worksheet. However, when I try to do it in VBA, it does not seem possible. The help for ^Operator tells me that "Number can be negative only if exponent is an integer value". Does...- Yornoc
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
