If Number < - ExcelBanter

Posted to microsoft.public.excel.misc

juanpablo

external usenet poster

Posts: 108

If Number <

Hi,

I need to create a formula to apply discount percentage.

If x < 2000001 then apply 56%
If 1000001 < x 2000000 then apply 49%
If 650001 < x 1000000 then apply 47%

And so on.

Thanks

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
countif formula to find the occurances of a number that is greater than one number but less than another	steveo	Excel Discussion (Misc queries)	3	July 8th 06 02:04 AM
convert text-format number to number in excel 2000%3f	Larry	Excel Discussion (Misc queries)	1	July 29th 05 08:18 PM
Count number of times a specific number is displayed in a cell ran	subs	Excel Worksheet Functions	1	June 27th 05 05:01 PM
excel format cells/Number/Category: Number problem	Matts	Excel Discussion (Misc queries)	5	December 9th 04 09:47 PM
Rounding a number to a multiple quantity that adds to a fixed total number	wjlo	Excel Worksheet Functions	1	November 9th 04 04:43 PM

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

Menu

About Us