LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 170
Default Can excel calculate?


"Karl Itschen" wrote in message
...
Please note that C++ does it right!

#include <iostream
#include <math.h
using namespace std;
int main()
{
double tempRound;
double tempInt, tempDec;
double number;
number = 64.1;

tempRound =floor(number*10+0.5)/10;
tempInt = (int)(tempRound);
tempDec = 10*(tempRound - tempInt);

cout << "tempRound = " << tempRound << endl;
cout << "tempInt = " << tempInt << endl;
cout << "tempDec = " << tempDec << endl;

system("pause");
return 0;
}

gives the right result:

tempRound = 64.1
tempInt = 64
tempDec = 1


Well of course it does

The default precison used for doubles by cout
is only 6 decimal places

Try

cout.precision(15);

if you want a real comparison.

http://msdn.microsoft.com/library/de...recisio n.asp

Keith






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to calculate e^2 in excel sif Excel Discussion (Misc queries) 3 April 4th 23 02:09 PM
How can I calculate Ker and Kei using Excel Binder Excel Worksheet Functions 2 March 2nd 09 06:49 AM
Excel Won't Calculate davem97132 Excel Worksheet Functions 1 June 5th 08 01:51 AM
Excel won't calculate Keith Excel Discussion (Misc queries) 2 May 12th 08 09:56 AM
calculate age in excel so I can add it Joe Phillips Excel Discussion (Misc queries) 1 July 11th 07 02:04 PM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"