for
2000
3000
4000
......
10000

Thanx
Sachin

"Max" wrote:

C2 will return 9.52%

with C2 formatted as percentage (to 2 dp)
(via Format Cells Percentage 2 dp OK)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----