Relation betwn 2 sets of data, user to input one, sheet returns ot

A

AndyB

I have a graph which draws a line Rotations vs Time.
I want to make a cell where I can enter any amount of rotations and then
return the time in to another cell. Problem is it's not an easy relationship
between rotation and time.
Data:
Revs Time
5 20
10 40
15 55
20 70
25 85

If somone inputs 12 revs, the result should be 45
 
A

AndyB

I have a picture of a graph so I can see that
8 = 35
12 = 45
18 = 65

But I want to be able to input anything from 5 to 30 and get the figure to
appear in another cell.
 
A

AndyB

Sorted,
Did some digging around here, came up with x = (y-intercept)/slope
This seems to be working.
Thanks all.
 

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

Lookup and average data in an unsorted list 1
set formula to display a data from a 5 columns table 3
IF calculation of Time 2
VLookup Data, Find 2 Adjacent Rows, Return Value in 1 Row 3
Linear Regression 1
<<Extracting the desired data with an formula>> 10
Sum of data between two dates - tried SUMIF and it returned "0" 2
Dynamic Data Validation in VBA. I s it possible? 0

Top