One way ..

Assume the known data below is in A1:B2

2000 13%
10000 8%

and C1 contains 7569

Put in say, C2: =FORECAST(C1,$B$1:$B$2,$A$1:$A$2)

C2 will return 9.52%
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Dr. Sachin Wagh" wrote in message
...
Is there any way in which I could arrive at a trend on reducing percentage
Starting with 13% for 2000 &
Dropping to 8% for 10000
So basically, when I put any value between 2000 & 10000; say, 7569 in c1,
I
get the corresponding % in c2

--
Dr. Sachin Wagh
MBBS, DHA, DPH