Technical Skill Tuesday: The Strangest Excel Formulas in the Book|
April 10, 2012| 0
Need to spell out a number automatically? Who doesn’t? Well, Excel has your answer– just use :
Did you enter in some of your values with negative signs on the wrong side of your number (As in, you wrote 200- instead of -2000? Don’t worry, you don’t have to tell anyone you did that– you can just use:
Do you feel the need to pick a completely random number from your dataset? Of course you do. Why wouldn’t you? For that, use:
Remember having to convert degrees to radians in middle school? Well, don’t let your children near the computer when they’re doing their math homework because they can just use:
Next Tuesday: Economic analysis shortcuts.