ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Relationship between number (https://www.excelbanter.com/excel-worksheet-functions/236533-relationship-between-number.html)

Damon Cavanagh

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



All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com