Posted to microsoft.public.excel.misc

external usenet poster

Posts: 132

Excel formulae

I need to work out discount rate from price
Example
50 divided by 1.1 gives me the correct result 45
But if I divide 150 by 1.2 instead of giving me 120 the result is 125
I need one formulae I dont want work out first the discount rate and then
price - discount

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
Formulae: Paste value formulae after doing an average operation	Lim	Excel Discussion (Misc queries)	4	April 20th 08 07:31 PM
excel formulae	Jimi	Excel Worksheet Functions	7	August 2nd 07 10:48 PM
using formulae in excel	conroy	Excel Worksheet Functions	4	January 10th 07 08:04 PM
excel formulae	zemarko	Excel Discussion (Misc queries)	1	August 3rd 05 05:41 PM
Searching TEXT in formulae, rather than results of formulae	AndyE	Excel Worksheet Functions	1	July 15th 05 10:57 AM

All times are GMT +1. The time now is 08:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us