Calc a value based on boundaries

K

Knoxi

I have an upper and lower boundary for a value with an associated upper and lower score and want to establish what the score is for each value. e.g.

Value Lower Boundary Upper Boundary Lower score Upper score
60 0 100 0 5
60 100 0 0 5
60 120 30 0 5

I have worked out a formula to achieve this but wondered whether there might be a specific function to do the same job. The value need not be limited to the upper and lower boundaries (eg. the first row might have a value of, say, 120) so the score could be higher than 5 or lower than 0.


Any ideas are welcome.

Thanks
G


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDIRECT informulas 2
i want a cel is to follow another cel's content but it shows a zero(0) if the first cel is empty!? 3
How can i see a data change? 1
Comparing a cell value with a range in a table and displaying a response 0
How do I auto fill a date series 2
Generate series according to range and increment 5
Calculate score from Scale 5
Change Case in a column 2

Top