Blackberry Megatron Shock & Awe 9000
By BankersBall on May 12, 2008 in BlackBerry | comments(0)
Actually it’s called the Blackberry Bold. More
By BankersBall on May 12, 2008 in BlackBerry | comments(0)
Actually it’s called the Blackberry Bold. More
By BankersBall on Apr 16, 2008 in BlackBerry | comments(6)
Yes, poses. Because I can’t think of a better word. More
By BankersBall on Apr 8, 2008 in BlackBerry | comments(1)
A solution to add a signature only sometimes.
By BankersBall on Feb 28, 2008 in BlackBerry | comments(1)
Spend even more time gazing at your “device.”
By BankersBall on Feb 11, 2008 in BlackBerry | comments(0)
Often need to type é, ó, ü or other accented letters in your emails?
By BankersBall on Jan 29, 2008 in Excel, Excel Shortcuts | comments(1)
03 and 07 users, rejoice. More
By BankersBall on Jan 13, 2008 in BlackBerry | comments(0)
Like Ctrl-Alt-Delete, but for your Blackberry.
By BankersBall on Dec 11, 2007 in Ask BBallers, Cube Life, Excel | comments(5)
A reader asks fellow BBallers for help on the Excel front. More
By BankersBall on Dec 3, 2007 in BlackBerry, Excel | comments(4)
Quick tips on how to wade through that mess that is your inbox.
By BankersBall on Nov 20, 2007 in Excel, Excel Shortcuts | comments(0)
Want to send an Excel 2007 file on, but remove all of your digital fingerprints? More
By BankersBall on Nov 8, 2007 in BlackBerry, Excel | comments(1)
Ever wonder just how good your reception is?
By BankersBall on Oct 29, 2007 in Cube Life, Emails & Diversions, Excel | comments(8)
A UK reader forwards us “Project: Get a Life — Intrinsic Valuation of a Banker’s Life” — a DCF valuation. Enjoy!
By BankersBall on Oct 29, 2007 in BlackBerry, Excel | comments(2)
Along the lines of our Excel shortcuts, we’re going to start a series of helpful tips for Blackberry users.
By BankersBall on Oct 21, 2007 in Excel, Excel Shortcuts | comments(29)
A reader writes in with the question: “Do you know of any keyboard shortcut to increase and decrease decimal in Excel? I’ve been trying for weeks to find something, but haven’t been able to. I’ve heard its not possible unless you just program a macro.” We come up with a few workarounds… More
By BankersBall on Jul 31, 2007 in Excel, Excel Shortcuts | comments(3)
![]() |
SHORTCUT:
=ROUND(A1,A2-1-INT(LOG10(ABS(A1))))
where A1 = cell containing value you want to round and A2 = number of significant digits.
PURPOSE:
Round a number to __ significant digits.
FURTHER EXPLANATION:
ROUND(), ROUNDUP() and ROUNDDOWN() allow you to round but not preserve a specified number of significant digits. Source: OzGrid.