#### Determining A Rating

```Hello,

Suppose I have the following table:

A    B     C
1   3   <3.80
2   3-   3.80  3.99
3   4+   4.00  4.19
4   4    4.20  4.79
5   4-   4.80  4.99
6   5+   5.00  5.19
7   5    5.20  5.79
8   5-   5.80  5.99
9   6+   6.00  6.19
10  6    6.20  6.79
11  6-   6.80  6.99
12  7    7.50  7.99
13  8    8.50  8.99
14
15  4.91
16  4-

Where A is a rating/score
B is the low value range
C is the high value range

If I have a value in A15 of 4.91 (which is in the range of 4.80 and
4.99), I would like to return a rating in A16 of 4-.  I've tried using
a series of IF statements, but there seems to be a string limitation.
I've also tried using the VLOOKUP function, but I can't seem to get a
correct answer.  Can anyone suggest an alternative to my predicament.

Edwin
```
 0
10/30/2003 7:47:21 AM
excel 39879 articles. 2 followers.

1 Replies
732 Views

Similar Articles

[PageSpeed] 45

```one way:

Change B1 to 0, then use

=INDEX(A:A,MATCH(A15,B:B,1))

edwin.t.villamayor@citigroup.com (Edwin Villamayor) wrote:

> Hello,
>
> Suppose I have the following table:
>
>      A    B     C
> 1   3   <3.80
> 2   3-   3.80  3.99
> 3   4+   4.00  4.19
> 4   4    4.20  4.79
> 5   4-   4.80  4.99
> 6   5+   5.00  5.19
> 7   5    5.20  5.79
> 8   5-   5.80  5.99
> 9   6+   6.00  6.19
> 10  6    6.20  6.79
> 11  6-   6.80  6.99
> 12  7    7.50  7.99
> 13  8    8.50  8.99
> 14
> 15  4.91
> 16  4-
>
> Where A is a rating/score
>       B is the low value range
>       C is the high value range
>
> If I have a value in A15 of 4.91 (which is in the range of 4.80 and
> 4.99), I would like to return a rating in A16 of 4-.  I've tried using
> a series of IF statements, but there seems to be a string limitation.
> I've also tried using the VLOOKUP function, but I can't seem to get a
> correct answer.  Can anyone suggest an alternative to my predicament.
>
>
> Edwin
```
 0
jemcgimpsey (6723)
10/30/2003 7:56:34 AM

Similar Artilces:

determine mail flow problem!!!!!!!!
Help! :-( Our mailflow from 2 backend 2003 exchange servers keeps queuing up in the outbound queue (which is set to always run delivery). Messages stay in there from 10 to 120 minutes before being sent to our gateway MTA and then sent off site (to hotmail.com for example). However when I telnet from a backend server to the gateway over port 25 and send a test message it goes right away. I can't for the life of me figure out why. One example when viewed in message tracking history says: 10:16am - smtp: store driver, message submitted from store 10:16am - smtp: message submitted to ...

Exchange Rate on Bank Transfer
Is there a way to modify the exchange rate on a bank transfer in the bank transfer screen? It seems I have to enter the Exchange Rate tables and modify the system wide exchange rate. What if the exchange rate for one transaction is different from that of another (since I have multiple bank accounts)? Adam, You can always change the exchange rate on the foreign currency checkbook whether you are transferring from or to it. If the exchange rate does not exist for the date of the transaction, the system will prompt you for a valid exchange rate depending on whether your exchange rates ar...

Update online prices and exchange rates
I have Money 2001 OEM Version 9 About four months ago I started getting error messages for downloads of stock exchange indices for Sydney, London and Hong Kong. Eg "Money was unable to retrieve an online price for All Ordinaries (Sydney). The symbol \$US:SYDI is not recognised." Money allows me to select stock exchange indices but I cannot find how to change the symbol. Any Suggestions? These stopped working for 2001 versions in May i think. Microsoft made changes to the MSN Money site, and they didn't check versions as far back as 2001, which appeared to break these ty...

Determine columns used
I have 100+ spreadsheets which i have to edit into a certain format. The spreadsheets currently have 100 columns (from 1-100). From there i have to reduce the number of columns set to 8 columns. E.g: 1 2 3 4 5 6 7 8 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 (from column 9 onwards, it goes to the 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 next rows' column 1) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 How do i do that without altering the order of the value of the cell? Let me make sure we understand the question. You have ...

Dynamically determining when a month ends
Hello all, Ok, I have a simple excel spreadsheet, where I keep track of my spending on one tab, my income in another and my summary in a thrid. My problem happens when I try to dynamically calc. avg's for months in the summary page. For instance, if I want to see how much money I spent on average per month, or even per day, I draw from the data entered into the spending page. Now, the spending page is set up with the following columns: Date:: Description:: Amount The problem with this is that I can't predefine a max row # for each month, since I might have 80 entries in spending...

how to determine the size of the sheet
Hi I had a collegue who told me once a way to dtermine the number of the rows in a sheet of the workbook I am working at. It is known that when you open a new workbook each sheet has maybe 65365 or something like that rows. MY QUESTION IS: HOW TO MAKE THE SHEET 1000 ROWS OR WHATEVER NUMBERS OF ROWS I ONLY NEED? Thanks in Advance, Ahmed Hi Ahmed The number of rows and columns are fixed. Your workaround would be to hide the ones you consider unneeded. HTH. Best wishes Harald "Ahmed SHEBL" <ahmad.shebl@hotmail.com> skrev i melding news:%231uFO3IcHHA.4720@TK2MSFTNGP0...

APR intrest rates
anybody know any formulas for working out the monthy interest rate you would get from an APR and any other bank rate systems? cheers ...

How do I determine
I have X number of rows that show employee names and a column (A2) that lists the value of products sold by each employee and I want to pay them a percentage based upon value of sales. For example: If they sell up to =A31,000 worth of products, I will pay them 3% of the value. Between =A31,000 & =A32,000, I will pay them 5% of the value Over =A32,000, I will pay them 10% of the value The amount paid to them in commission will be show in column (A3). Many thanks D.Haste darren.haste@ttt.co.uk "Hastey" <darrenhaste@sky.com> wrote in message news:6a0a4fa9-adcd-484a-80...

I'm trying to scan a list of servers for a specific file (say for example \\<servername>\C\$\MyApp\Test.ini\which may exist on some servers but not on others. In addition, I may not have have access to all servers that I'm checking. When using any commands in Powershell (1.0) that attempt to get the file (such as Get-Item) PowerShell returns the same "Cannot find path '<filename>' because it does not exist.)" error message in the following two scenarions: 1. I have access to the remote filesystem and the file does not exist (expected beha...

projected sales forecast broken down into an hourly rate not linea
I'm trying to make a spreadsheet program that allowes me to predict projected sales per hour when given a projected total for the day, but I have no idea of how to make a spreadsheet like that. In addition to this I would like to add a column that will allow me to write in the acutual sales per hour so as to decide whether or not I should call more people in or send people home. As noted above I do not want to make it as a linear equation but rather use something to get an accurate gage for sales per hour based on peak hours and such. Thanks ...

Determining A Rating
Hello, Suppose I have the following table: A B C 1 3 <3.80 2 3- 3.80 3.99 3 4+ 4.00 4.19 4 4 4.20 4.79 5 4- 4.80 4.99 6 5+ 5.00 5.19 7 5 5.20 5.79 8 5- 5.80 5.99 9 6+ 6.00 6.19 10 6 6.20 6.79 11 6- 6.80 6.99 12 7 7.50 7.99 13 8 8.50 8.99 14 15 4.91 16 4- Where A is a rating/score B is the low value range C is the high value range If I have a value in A15 of 4.91 (which is in the range of 4.80 and 4.99), I would like to return a rating in A16 of 4-. I've tried using a series of IF statements, ...

How do I determine the size of an excel worksheet?
How do I determine the size of an individual worksheet in an Office Excel 2003 file? The Properties featue only tells me the size of the whole file. Hi not directly supported by Excel. One workaround: Export this sheet to a separate workbook (with only this sheet) and measure its size -- Regards Frank Kabel Frankfurt, Germany "rajivsahib" <rajivsahib@discussions.microsoft.com> schrieb im Newsbeitrag news:7031AE58-EB7A-44CD-9AF5-940BD47DAA8B@microsoft.com... > How do I determine the size of an individual worksheet in an Office Excel > 2003 file? The Properties featue o...

Display SCL rating
Hi, Is it possible to display SCL rating in OWA and/or Outlook2k/2k3 ? TIA Steven On Thu, 8 Dec 2005 17:55:37 +1100, "Steven Wong" <sazabi75@hotmail.com> wrote: >Hi, > >Is it possible to display SCL rating in OWA and/or Outlook2k/2k3 ? >TIA > >Steven > More of an application thing. The rating is in the headers so you could get it out. It's not an Exchange question because Exchange does already display it, it's just Outlook chooses not to display it. You might like to do some checking on the public featureset of the new version of Office and yo...

Determine if a sheet is protected?
How can I determine if a sheet is protected or not? thank u Try activesheet.protectcontents HTH Bob "Robert Crandal" <nobody@gmail.com> wrote in message news:h865n.9557\$Ft3.8620@newsfe04.iad... > How can I determine if a sheet is protected or not? > > thank u > > Sub test() MsgBox ActiveSheet.ProtectionMode 'returns true or false End Sub Gord Dibben MS Excel MVP On Mon, 18 Jan 2010 16:28:18 -0700, "Robert Crandal" <nobody@gmail.com> wrote: >How can I determine if a sheet is protected o...

Determining OS?
Is there a method to determine the operating system (98, XP, ME, etc) that a program is running under? Thanks, -- Knute Johnson email s/nospam/knute/ Molon labe... >Is there a method to determine the operating system (98, XP, ME, etc) >that a program is running under? See the GetVersionEx API. Dave -- MVP VC++ FAQ: http://www.mvps.org/vcfaq David Lowndes wrote: >>Is there a method to determine the operating system (98, XP, ME, etc) >>that a program is running under? > > > See the GetVersionEx API. > > Dave Thanks. -- Knute Johnson email s/n...

Other field Determination
Imagine this situation...there are: Owners (tblOwners) Pets (tblPets, child records of tblOwners) Medicines (tblMeds, child records of tblPets) Owners can have multiple pets. Pets have multiple medicines. Easy so far. Here's the tricky part. The Pets can be of different species (cat, dog, bird, snake, etc). Depending on what the species is, I want to determine the other data that needs to be stored for the pet. So instead of just height, weight, age, as fields in the pet table, I want to see number of whiskers, declawed? if its a cat...wingspan, beaklength, feather color if its a bi...

How to determine Resources for a ServiceAppointment?
I am creating a custom view to list resources for each serviceappointment. Here is the basic query I have used that seems to produce the correct results: SELECT * FROM serviceappointment JOIN ActivityParty ON (ServiceAppointment.ActivityId = ActivityParty.ActivityId) AND (ActivityParty.PartyObjectTypeCode = 112) JOIN systemuser ON (ActivityParty.OwningUser = systemuser.systemuserid) WHERE (serviceappointment.StateCode <> 2) My question is why ObjectTypeCode = 112. Isn't that for Incident, not for ServiceAppointment? Can anyone clarify for me please? Thanks, Richard ...

Determining a Date
I have a column which is title, Expected Completition Date. Therefore multiple dates can be used. For example, July 1, July 17, August 31, August, 9, September 16, August 2, July 31, in that order. So for this project to be completed, it would be on September 16. I want the total field at the bottom to display the latest date of completion. =MAX(range) -- Carlos "Mark" <Mark@discussions.microsoft.com> wrote in message news:E0D47212-DCFE-4C47-84AB-708C4838E81E@microsoft.com... >I have a column which is title, Expected Completition Date. Therefore > multiple da...

how to determine schemas for validation
I am trying to validate document parts of Office 2007 documents. The method I have tried using is to sort through each XML file to see which namespaces are used, load the corresponding schemas for those namespaces, then try to validate the document against that schema set. When it gets to more complicated documents, for example a Word document utilizing many features, several open office XML schemas might be used. When I try to load them all into a XmlSchemaSet, it won't compile because certain elements will have been declared more than once. For example, if I load the following schemas ...

IMFv2 SCL rating in the header
I have configured the following setting in order to see the SCL rating for the blocked messages. Is there a way to have all messages that get processed by IMF (not just the rejected ones) marked with a SCL rating rating in the header? HKEY_LOCAL_MACHINE\Software\Microsoft\Exchange\ContentFilter Thanks! Fairly certain you can't. However, there's a way to have them show up in Outlook. http://blogs.technet.com/exchange/archive/2004/05/26/142607.aspx or in OWA http://blogs.technet.com/exchange/archive/2004/05/27/143297.aspx -- Bharat Suneja MCSE, MCT www.zenprise.com blog: www....

Vista UAC/Privilege determination
I have two intercommunicating processes. Process A sets a hook into process B (for purposes I can't talk about due to NDA issues). The problem I'm having is this: if I run A as an ordinary user, it can't set a hook in B if I run A as administrator, it can hook B, but when the hook runs in B, it can't PostMessage back to A. It appears that I have a situation where if A is an administrator, then B is running at a privilege level lower than A but higher than an ordinary user. So while I can hook it, I can't have it send back to me. But running as a limited user, I can&#...

determine what program is used to view html link in outlook message
where do I set up the program that will be used to view links in html outlook messages? Last I knew Outlook used the default browser on your system. "Allan J. Behr" <al@thebehrs.net> wrote in message news:FF55A15C-F12A-4646-9775-EAE0091D8A33@microsoft.com... > where do I set up the program that will be used to view links in html > outlook messages? ...

Help me determine what I whould buy.
I'm a DB programmer running Windows ME on my home system, while all my customers are running Windows XP. I want to be able to take screen shots of forms that I create. Latter I may want to produce DB diagrams, but that's not important now. If I need to upgrade my system to XP, I will. What version of Visio should I buy? I know how simple this is to someone knowing this product, but I'm not there yet, sorry. You need Visio Professional edition for Software and Database functionality. The latest version is Visio 2003, which only runs on Windows 2000 or Windows XP. If you de...

How to determine the ranking positions?
Does anyone have any suggestions on how to determine the ranking positions? There is a list of numbers under column A, I would like to determine the ranking number starting from max to min. Does anyone have any suggestions? For example, 5 Rank (3) 3 should be returned under column B 4 Rank (4) 4 should be returned under column B 6 Rank (2) 2 should be returned under column B 8 Rank (1) 1 should be returned under column B EXCEL 2007. 1. In cells A2 to A5 enter:- 5 4 6 8 2. Give the above a Range Name of:- RangeName 3. In cell B2 type:- =RANK(A2,RankRange...

data determines which table to use
Access XP. I have a table that has the fields "Extension code" and "Description" and I have a form where an "Extension code" is going to be entered following this criteria: (a) If the extension code is known it will be entered by the user and the field "Description" is filled by the form (b) If the extension code is unknown a 000 will be entered by the user and the "Description" is filled by the user My problem is that the "extension code" 000 has a relationship of one-to-many while the rest of the extension codes are a one-to-...