the new "improved" method is Tools, Goal Seek

A1=0.0313
B1=your formula
C1= your reference / target value
D1=b1-c1

Then tools, Goal Seek
Set Cell: D1
to Value: 0
By changing cell: A1

This should then iterate through until it finds a solution


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=274556