PC Review


Reply
 
 
=?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
 
Reply With Quote
 
 
 
 
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I view an excell document without excell (not installed wit. Gordon Microsoft Excel Misc 8 2nd May 2006 05:41 AM
how do you open an excell email attacment, if I dont have excell =?Utf-8?B?R2FyeQ==?= Microsoft Excel Misc 1 22nd Feb 2006 11:26 PM
insert query into excell sheet to update excell sheet and pivot table vbsolo Microsoft Excel Misc 0 24th Aug 2005 12:41 PM
Can I view an excell document without excell (not installed wit. =?Utf-8?B?S2V2aW4=?= Microsoft Excel Misc 1 16th Feb 2005 09:27 PM
VERTICAL TEXT IN EXCELL SPREADSHEET (EXCELL 2003) C. HALL P.E. Microsoft Excel Worksheet Functions 3 29th Jan 2004 06:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:12 AM.