## Recipe 7.5. Using Trigonometry Functions## ProblemYou need to become familiar with Excel's support for trigonometric functions . ## SolutionExplore the trigonometric functions summarized in Table 7-5.
## DiscussionThe trigonometric functions take or return angles in radians. However, often degrees are more convenient to work with. Excel provides two functions making conversions between radians and degrees easy: |

## Recipe 7.6. Seeing Signs## ProblemYou want to capture only the sign of an expression, not its value. Or you want to take the absolute value of an expression. ## SolutionUse the ## DiscussionSituations often arise in scientific calculations when you're more interested in the sign of an expression than in the resulting value. For example, the formula =$F3-$E$8/(ABS(G$2/$F$2))*ABS(G$2/$F$2)^0.1*SIGN(G2-F2) uses the In this particular case, the expression You'll notice that in the example formula discussed a moment ago, I also used the absolute value function, |