Uncategorized
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 :
=SpellNumber(A1)
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:
=SUBSTITUTE(IF(RIGHT(TRIM(A1))=”-”,RIGHT(TRIM(A1))&A1,A1),”-”,”",2)+0
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:
=RAND()
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.
0 Comments
