| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inernal function for finding y
I have two points, (x1, y1) and (x2, y2)
Is there an internal function that can calculate the value of y for a particular x? Or do I need to establish the linear equation from finding slope and intersection points, then substitute the new x into it? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inernal function for finding y
One way:
See FORECAST() in XL Help In article , "Lamb Chop" wrote: I have two points, (x1, y1) and (x2, y2) Is there an internal function that can calculate the value of y for a particular x? Or do I need to establish the linear equation from finding slope and intersection points, then substitute the new x into it? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Having trouble finding the right function | New Users to Excel | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Help Needed with Finding a Function | New Users to Excel | |||
| function for finding a value! | Excel Worksheet Functions | |||
| Finding a function in Excel | Excel Worksheet Functions | |||
Linear Mode
