look up values help needed

look up values help needed

Hi,

I have a table that returns rows with a total weight (say 212.5 for example). I have another look up table that has range of weights with a corresponding dollar value

The look up table looks like this: (example)

kg     value
0       2.00000000000000000000
160.5   2.35000000000000000000
195.5   2.55000000000000000000
220.5   2.75000000000000000000
245.5   2.83000000000000000000
270.5   2.89000000000000000000
295.5   2.92000000000000000000
320.5   2.95000000000000000000
345.5   3.00000000000000000000
445.5   2.35000000000000000000

so in my case, (212.5kgs) I need to return the value of 2.55 as 212.5kgs is between 195.5 and 220.5

can anyone help how I can do this please?

Kind regards Harry

View Answers

Ads









Related Tutorials/Questions & Answers:
look up values help needed
look up values help needed  Hi, I have a table that returns rows with a total weight (say 212.5 for example). I have another look up table that has range of weights with a corresponding dollar value The look up table looks like
Help needed in JSP
Help needed in JSP  Hi .. I want to Update the multiple values of database using checkboxes and want to set the session for selected checkboxes..? please answer if any one knows as soon as possible
Advertisements
ModuleNotFoundError: No module named 'look-up'
ModuleNotFoundError: No module named 'look-up'  Hi, My Python...-up' How to remove the ModuleNotFoundError: No module named 'look-up... to install padas library. You can install look-up python with following command
ModuleNotFoundError: No module named 'look-up'
ModuleNotFoundError: No module named 'look-up'  Hi, My Python...-up' How to remove the ModuleNotFoundError: No module named 'look-up... to install padas library. You can install look-up python with following command
help Needed with requirements
help Needed with requirements  Following are my requirements : * Maintain a student database *Based on a student's test results ,reports should be generated so as to project details such as a students weakness in a particular
Java help needed
Java help needed  Create a web application that will allow a user... as needed by the number of characters of the chosen word. 2. Add 4 buttons or menu options: One for accessing help using the program, one for adding new words, one
urgent help needed!!!!
how to access values selected from connected comboboxes  how to access values selected from connected comboboxes for storing in database...i'm... access country and state....please help me.... 1)state.jsp: <%@page import
urgent help needed!!!!
comboboxes for storing in database  how to access values selected from connected comboboxes for storing in database...i'm attatching a code i got.......please help me.... 1)state.jsp: <%@page import="java.sql.*"%>
Code Help Needed
Code Help Needed  I am trying to help a buddy of mine with this program and I can't seem to figure it out. I am still working on it but any help...[test]); line. Again thank you for any help. import java.util.*; import
Help needed for Form Validation please help!
Help needed for Form Validation please help!  I have created a page.../password combination . Problem arises while validating the Sign up part as after clicking the submit button for sign up it also goes through the jsp code and returns
help needed - Java Interview Questions
help needed  What are the new features added in jdk 1.5?  Hi friend, The following were the new features added in java 1.5.... * Autoboxing/unboxing ------------------------- This link will help you
servlet redirect problem help needed
servlet redirect problem help needed  package p; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import
servlet redirect problem help needed
servlet redirect problem help needed  package p; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP   The Task Write a class whose objects will represent students... and exam marks (add them up and divide by two) are greater than
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP
CAN ANYONE SOLVE THIS FOR ME. URGENT HELP NEEDED. PLEASE HELP   Write a class whose objects will represent students.The class should have three...? depending on whether or not the combined coursework and exam marks (add them up
Help needed on java standalone app and default browser interaction.
Help needed on java standalone app and default browser interaction.  Hi Developers and tutors, Is anyone able to guide on how am i able to extract...? Platform Windows Browser IE7 Any from of help would be deeply apperciated
please help me how to set up Netbeans for JSP
please help me how to set up Netbeans for JSP   Hi roseindian.net... help me.We are ready to do INDUSTRIAL PROJECT by JSP. Thank you. ERROR.../xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Encoding: gzip,deflate,sdch
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap   i want to create invoice report .. help out asap
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap
i want to create invoice report editable. values should be taken from dabase and editable .. help out asap   i want to create invoice report editable. values should be taken from dabase and editable .. help out asap
I want to update the multiple values of database depending on checkbox..? Please help me out..
I want to update the multiple values of database depending on checkbox..? Please help me out..   Hi .. I want to Update the multiple values of database using checkboxes and want to set the session for selected checkboxes
Can anybody help how to store values to the following xml from .NET application
Can anybody help how to store values to the following xml from .NET application  Can anybody help how to store values to the following xml from .NET application <SQLSchema> <Databases>
Help...
Help...  Write a class that displays your first name vertically down the screen ?? where each letter uses up to 5 rows by 5 columns of a character input by you with a blank line between each letter
help
display all the computed values in the previous assignments in a text area. ... proper screen layout models. Your frames should look clear and display all... based on the percentage of cheating. please help me
ModuleNotFoundError: No module named 'look'
ModuleNotFoundError: No module named 'look'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'look' How to remove the ModuleNotFoundError: No module named 'look' error
ModuleNotFoundError: No module named 'look-at'
ModuleNotFoundError: No module named 'look-at'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'look-at' How to remove the ModuleNotFoundError: No module named 'look
A program solution needed
A program solution needed   I need a solve for this problem please ! a program that displays grade statistics. The program should read any number of grades (up to 100) and ends when the user enters -1, the program should reject
Packages needed for JDBC in Linux
Packages needed for JDBC in Linux  Can anyone tell me the packages needed to run a program with JDBC in Red Hat 5
help
help  pls help me to get the code of a java program a program to perform different shapes in a menu using javaapplet
help
help  i need help with this code. write a java code for a method named addSevenToKthElement that takes an integer array, and an integer k as its arguments and returns the kth element plus 7. any help would be greatly
HELP
HELP  I need this code to open in a new web browser. but no matter what i do it wont please help?? Directive 055 Storage Requirements for the Upstream Petroleum Industry
Help
Help   i have a html file.. i have take input and store in database .. Tell me the steps to perform.. i have xampp it includes mysql,tomacat,apache. and how display the data from datbase .. please explain

Ads