Research shows that among the youngest Internet users, the primary creators of Web content (blogs, graphics, photographs, Web sites) are not misfits resembling the Lone Gunmen of “The X Files.” On the contrary, the cyberpioneers of the moment are digitally effusive teenage girls.
read more | digg story
Politics, Environment, Culture, Finance, Sports, Movies, Technology, Computers, Society, Internet, Corruption etc.. Everymatter you want to discuss should be discussed through Comments, Opinion and remarks here.
Search This Blog
Monday, February 25, 2008
Sunday, February 24, 2008
MS-Excel 2003
From last two months I am making comparative reports related to costing of material in MS-Excel. I have used many mathematical formulas and found that it possible to display a cell value with or without decimal value even if cell contains the result of some formula but if you use the value of this formula as a whole (without decimal value) in calculation with some other cell the result will be calculated taking in consideration decimal values also. Let me shown you an example
Cell A1 = 1012 * 0.6 (with decimal value the result will be 607.20)
Cell B1 = 15
Cell C1 = A1 * B1 = 9108
Use of 2 decimal point
The value of C1 is 9108 when you use 2 decimal points
Without 2 decimal point
The value of C1 is 9108 when you use 2 decimal points
In both the cases the result is same.
While in actual calculation if we calculate 607.2 * 15 = 9108 and 607* 15 = 9105.
I think it is a loophole in MS-Excel if anyone out of you knows the solution, please mention.
Cell A1 = 1012 * 0.6 (with decimal value the result will be 607.20)
Cell B1 = 15
Cell C1 = A1 * B1 = 9108
Use of 2 decimal point
The value of C1 is 9108 when you use 2 decimal points
Without 2 decimal point
The value of C1 is 9108 when you use 2 decimal points
In both the cases the result is same.
While in actual calculation if we calculate 607.2 * 15 = 9108 and 607* 15 = 9105.
I think it is a loophole in MS-Excel if anyone out of you knows the solution, please mention.
Saturday, February 23, 2008
Clouds gather as 'sulky' Musharraf retreats to bunker
Just classic. We long to spread democracy throughout the globe, as long as your people vote for someone we like. When they don't all bets are off
read more | digg story
read more | digg story
Dallas Cop Killed While Escorting Hillary Clinton
A Dallas police motorcycle officer who crashed Friday while escorting Democratic presidential candidate Hillary Rodham Clinton's motorcade to a campaign rally is dead, CBS station KTVT-TV, in Dallas reported.
read more | digg story
read more | digg story
Friday, February 22, 2008
Obama, Clinton agree to disagree
Sen. Hillary Clinton, needing a win in Texas to derail Sen. Barack Obama in the race for the Democratic presidential nomination, sought Thursday to contrast her opponent's rhetorical skills with what she called her superior ability to govern.
read more | digg story
read more | digg story
INDIAN BPO Case Employer to provide adequate security
As quoted on the website "In an unprecedented judgement that could have larger repercussions, the Supreme Court on Thursday ordered the prosecution of the former chief of Hewlett Packard's (HP) outsourcing business Som Mittal for not providing enough security to a woman staffer."
read more | digg story
read more | digg story
The 5 Deadliest Effects of Global Warming
Green house gases stay can stay in the atmosphere for an amount of years ranging from decades to hundreds and thousands of years. No matter what we do, global warming is going to have some effect on Earth. Here are the 5 deadliest effects of global warming.
read more | digg story
read more | digg story
Subscribe to:
Posts (Atom)