Forum Discussion
Helper IIWhy does the formula VALUE("2a") return 0.0833333 ?
Yes the other solution worked for me, thank you! I was just curious about why exactly the "a" was allowed to be converted to a number. Thanks again!
Community ChampionHi aallman
Seems like the letter "a" represents the angle in Radians that its SIN = its value i.e. ( SIN ( a ) = a ) which is 0.0416667 rad = 1/24 rad = 2.3873 degrees. If preceded by a number (X) where 0 < X < 24 the result of VALUE is just the multiplication of X times a. This has something to do whith 1 hour per 24 hours a day (1/24).
The bottom line it does not matter just ignore it.
Have the solution I provided in your other post worked with you?
Have a good day.
Helper IIYes the other solution worked for me, thank you! I was just curious about why exactly the "a" was allowed to be converted to a number. Thanks again!