Excel Formula vs SQL Server Math

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Excel Formula vs SQL Server Math

Author

Topic

X002548
Not Just a Number

15586 Posts

Posted - 2007-10-24 : 12:38:30

Anyone have any ideas if Excel rounds differently than SQL server?

We are trying to convert function and some match bang on, and others can be off like 20 units

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-24 : 12:39:49

Could you provide an example? Perhaps we can get SQL Server to round the same way.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-24 : 12:53:13

please follow the the steps described here:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-24 : 12:58:11

Are you referring to "Banker's rounding"?

E 12°55'05.25"
N 56°04'39.16"

X002548
Not Just a Number

15586 Posts

Posted - 2007-10-24 : 13:23:44

Never mind guys..sorry for the red herring

The spec's didn't match the business requirement

I like having that kind of ammo

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

X002548
Not Just a Number

15586 Posts

Posted - 2007-10-24 : 15:42:24

But I would still like the last 3 hours back though

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-10-24 : 15:53:06

quote:
Originally posted by Peso

Are you referring to "Banker's rounding"?

E 12°55'05.25"
N 56°04'39.16"

Famous trainwreck threads:

Bankers Rounding
http://www.sqlservercentral.com/Forums/Topic370393-8-1.aspx

then the flamewar continued at:

Son of Bankers Rounding
http://www.sqlservercentral.com/Forums/Topic373178-8-1.aspx

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources