Excel Formula

4 comments

Rate

Anonymous Poster	Excel Formula 08/25/2010 12:12 AM
	hI, aLL In Excel calculate 23 x 35.56 x 0.85 = 695.20 Manual calculate 23 x 35.56 x 0.85 = 695.29 how to correct the excel formula to get 695.29 Regard's Newbie
	Reply

Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

nick name Guru Join Date: Mar 2007 Location: City of Light Posts: 3943 Good Answers: 183	#1 Re: Excel Formula 08/25/2010 3:01 AM
	Correct first your hand computation: 695.198 rounded 695.20!
	Reply

The Prof Guru Join Date: Aug 2006 Location: Western Australia Posts: 767 Good Answers: 58	#2 Re: Excel Formula 08/25/2010 3:14 AM
	The answer given by excel is correct, why would you want to change it? Can not work out how you get your "manual" answer - maybe you can show your calculations. __________________ If you can't explain it simply, you don't understand it well enough. (A.E.)
	Reply

Anonymous Poster	#3 In reply to #2 Re: Excel Formula 09/01/2010 4:39 AM
	Check you cell formatting on numbers - decimal places.
	Reply

Participant

Join Date: Oct 2010

Posts: 2

10/11/2010 10:42 PM

uhm oh oh very complicated.........

I don't know why the two results are different?????

-----------------------

Copy to Clipboard

Anonymous Poster (1); ltm0807 (1); nick name (1); The Prof (1)

	Got Something to Say?
	Ask a Question Start a Discussion

	Aerospace
	BioMech & BioMed
	Chemical & Material Science
	Civil Engineering
	Communications & Electronics
	Education and Engineering Careers
	Electrical Engineering
	General Discussion
	Instrumentation
	Manufacturing
	Mechanical Engineering
	New Technologies & Research
	Software & Programming
	Sustainable Engineering
	Transportation

	Site Directories
	Forum Directory Blog Directory User Group Directory RSS Feeds CR4 Rules of Conduct CR4 FAQ Site Glossary Who's Online (110 right now) Show Members