excel help

[conneh]

Any idea why this following formulae is working for the first 2 cells, then afterwords it is just displaying NUM? Its just been dragged down using the copy function - so everything is in place?

http://conneh.godsgame.net/1.xlsx

Thanks

 

[richy22]

I cant even open it

 

[Magic Johnson]

Don't it's a virus.

 

[conneh]

Or its an excel document saved on a Mac?

 

[Magic Johnson]

Hehe.

 

[chris_182]

What's the formula? I can't view the link

 

[Johnc172]

you may need to add absolute references ($ sign) to the formula to make sure it's picking up from the right cells, as when you drag down it changes the reference point

 

[Andy.]

It is related to the value. Anything higher than 5 (or 6/7/8?) degrees gives an error. It is all maths that I have not done for more than 10 years so I really can't tell you why, but it is related to the value that you are applying the formula to rather than a technical error.

 

[conneh]

Yea i changed it from radians to degrees, and used the absolute referencing to make sure it didn't change certain variables. Sorted it thanks.