View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Damon Cavanagh Damon Cavanagh is offline
external usenet poster
 
Posts: 2
Default 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