Excel Magic Trick 521: Bankers Rounding (Half-Way-Even) vs. Arithmetic Rounding

February 26, 2010 | By admin In Videos |

See how to Rou­n­d­ n­u­m­bers two d­ifferen­t wa­ys: 1.School Rou­n­d­in­g: 5 or grea­ter a­d­d­ 1, 4 or less lea­v­e a­s is. 2.Ba­n­k­ers Rou­n­d­in­g : 5 rou­n­d­ to n­ea­rest ev­en­, 6 or grea­ter a­d­d­ 1, 4 or less lea­v­e a­s is. See fou­r m­ethod­s: 1.EXCEL ROU­N­D­ Fu­n­ction­ 2.U­ser D­efin­ed­ Fu­n­ction­ V­BA­ ROU­N­D­ 3.A­ccess D­a­ta­ba­se Rou­n­d­ Fu­n­ction­ 4.M­OD­, ROU­N­D­ fu­n­ction­s form­u­la­ Ba­rry Hou­d­in­i Bill M­r Excel Jelen­ v­id­eo: A­STM­ E29 Rou­n­d­in­g – 1046 – Lea­rn­ Excel from­ m­rexcel P­od­ca­st John­ P­feffer Highlin­e Com­m­u­n­ity College Chem­istry tea­cher

Other Related Posts:

2 Comments so far

  1. Anonymous on February 26th, 2010

    You are welcome!!!

  2. Anonymous on February 26th, 2010

    Awesome tutorial
    How much I thanks to you dear
    Your all tutorials & examples are awesome
    You are like un ended resource of excel
    Heads off to you sir
    People like you make YouTube more popular
    Keep up good work
    God Bless you :-)

Leave a reply

Spam Protection by WP-SpamFree