# Excell

=?Utf-8?B?YW1lcmljYXNtYXR0cmVzczg4ODg=?=
Guest
Posts: n/a

 28th Feb 2007
Does anyone no how to set a formula to do this,
there is different ranges like 0-499,500-799,800-999 and with each range
there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price
falls into the range need the percentage like 303=3.03 or 805=24.15. thanks
Mike

Gord Dibben
Guest
Posts: n/a

 28th Feb 2007
=LOOKUP(B1,{0,500,800,1000},{0.01,0.02,0.03})*B1

Gord Dibben MS Excel MVP

On Wed, 28 Feb 2007 11:28:15 -0800, americasmattress8888
<(E-Mail Removed)> wrote:

>Does anyone no how to set a formula to do this,
>there is different ranges like 0-499,500-799,800-999 and with each range
>there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price
>falls into the range need the percentage like 303=3.03 or 805=24.15. thanks
>Mike

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Gordon Microsoft Excel Misc 8 2nd May 2006 05:41 AM =?Utf-8?B?R2FyeQ==?= Microsoft Excel Misc 1 22nd Feb 2006 11:26 PM vbsolo Microsoft Excel Misc 0 24th Aug 2005 12:41 PM =?Utf-8?B?S2V2aW4=?= Microsoft Excel Misc 1 16th Feb 2005 09:27 PM C. HALL P.E. Microsoft Excel Worksheet Functions 3 29th Jan 2004 06:42 PM

Features