Posted to microsoft.public.excel.worksheet.functions

BrownsFan

external usenet poster

Posts: 8

Problem calculating Using a Percentage

I have a value of 289.2 in column A and a value of 325.1 in column B.
I created the the difference in percentage by using the following
calculation (325.1 - 289.2)/289.2. The percentage in 12.4%. When I
mutliply the calculated column of 12.4% by a value in another column,
39750, I get the value 4934. This is incorrect - the value should be
4929. Can someone please help?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
calculating a percentage	Jennnifer	Excel Discussion (Misc queries)	4	January 21st 08 11:04 PM
Calculating Percentage	Ms.shopalot	Excel Worksheet Functions	2	December 19th 06 02:22 PM
Calculating a Percentage	Reegan	Excel Worksheet Functions	2	November 9th 06 12:04 PM
Calculating a percentage with the end percentage in mind	Shadowshady	Excel Discussion (Misc queries)	2	June 17th 06 09:41 AM
Calculating Percentage	mconnolly	Excel Worksheet Functions	1	August 29th 05 09:48 PM

All times are GMT +1. The time now is 02:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us