| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to define relationship between two sets
I've been given a table with two columns and two rows:
ColumnA ColumnB 5 3 100 1 Each number in column B is a percentage of the corresponding number in column A, but the percentage changes depending on the amount in column A. I need a formula that, for any column A value between 5 and 100, will give me the column B percentage. The relationship between the two columns is linear, so that if you graphed all possible values, you'd get a straight line. Thanks for any suggestions. Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| define nonblank in a formula | Excel Worksheet Functions | |||
| How to Define a named Formula at the Worksheet level? | Excel Worksheet Functions | |||
| Insert-Name-Define How to change formula after-the-fact? | Excel Worksheet Functions | |||
| Formula via Define Name (not working) | Excel Discussion (Misc queries) | |||
| How can I create a formula using 2 %'s for 2 sets of ages in the . | Excel Discussion (Misc queries) | |||
Threaded Mode
