How to get the correct (minus) answer for a minus raised to a power

Hi Guys,

I'm having difficulty getting the correct answer when raising any minus number to a power, the minus number in question is the result of a Sin(x) function where 'x' is a cell reference.

So far the only way i have found to do this is to have this arrangement, =-(y^(2)) where y is the result of the Sin(x) function, trouble is I cannot use this format in my larger equation as having the minus outside causes all answers in the column to be minus which is incorrect.

Here is the equation in question:-

=ACOS((1-(D$4/D$5)^2*(SIN(K4)^2)))

The Sin^2 function in bold is the problem as it gives a positive answer for any value of 'K4' in radians.

If anyone knows a way of manipulating this part of the equation to provide the correct answer for positive and negative values of Sin(x), I would be very grateful if you could show me your method.


Many Thanks,

Jason

Hi Richard,

Thank you for your reply, it appears I got so caught up with rectifying my equation that I completely forgot basic mathematical theory...


Thanks again,

Jason