Posted to microsoft.public.excel.misc

Jacob Skaria Jacob Skaria is offline

external usenet poster

Posts: 8,520

discount formula

=A2-A2*A3

OR

=A2*(1-A3)

--
Jacob

"Ayman" wrote:

if A2=500 A3 20% discount A4 net amount what the formula is ?for A4

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
discount formula help	Grace	Excel Worksheet Functions	6	August 27th 07 08:45 PM
how to do formula with a fix discount	Paula	Excel Worksheet Functions	1	September 9th 06 03:50 PM
Discount Formula	Dave	Excel Discussion (Misc queries)	3	May 16th 06 12:41 AM
I need a formula to get a 15% discount from a # like $452,472.00	tia	Charts and Charting in Excel	1	December 2nd 05 04:06 PM
formula discount	need formula as soon as posible	New Users to Excel	3	June 10th 05 12:12 PM

All times are GMT +1. The time now is 11:17 PM.

About Us

"It's about Microsoft Excel"