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