Hello,

i am trying to calculate the Energy density for varying amplitude Stresses. As a result i have to deal with a data system consisting large amounts of tension and compression. I have written a Macro which can compute the Energy, but come across trouble when the compressive stresses come into account and theit powers are decimal. For example consider (-x)^y , x =20 and y=5. In this case excel gives you a result. On the other hand if y is 5.1 or anyother decimal value, then excel returns no answer. Is there any way to fix this? I have tried a similar method in Matlab and it provides solutions.

Thanks and regards
Hinubhai