Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relationship between number
In the table below, as A2 changes from 7% to 8% in A4 so would the
values in B and C. Note that B2 and B4 are 4.5% great than A2 and A4. this relationship needs to rename constant.I need the values for B5,C5, and C6 all the location where I have put the ? A B C 1 81.67% 18.33% 2 7.00% 11.50% 14.53% 3 82.49% 17.51% 4 8.00% 12.50% 14.80% 5 ?% ?% 6 9.00% 13.50% ?% How do I go about solving this by using a formula, Thank you for your help, in advance. Damon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
relationship between two scores | New Users to Excel | |||
Look up functions and a one to many relationship | Excel Worksheet Functions | |||
relationship between columns | Excel Discussion (Misc queries) | |||
Relationship Math Across a Row | Excel Discussion (Misc queries) | |||
Predicting new Ys given new Xs using known relationship for X and | Excel Discussion (Misc queries) |