Posted to microsoft.public.excel.misc

Jennnifer

external usenet poster

Posts: 7

calculating a percentage

If I receive a 7% rebate on my total cost of $100,00 why do the 2 formuals
produce differnet results?

=100,000*.93 = $93000

=100,000/1.07 = $93,457

Which is the correct formula to use?

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 percentage	Dabbles	Excel Discussion (Misc queries)	3	July 31st 07 11:40 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 12:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us