This is little complex for me so i need help...

I have a value in cell P1 and is always -ve.
This value is calculated by some tedious calcualtion in some other part of the sheet.

By entering value in Cell P2, the value in cell P1 will progress towards +ve number.

What i want is a formula or Macro to increment the value in Cell P2 by 0.01
until value in Cell P1 becomes +ve...

Below is the example of my manual calculation.

When i have
P2=0 P1=-23.58
P2=0.01 P1=-14.78
P2=0.02 P1= -9.30
P2=0.03 P1= -2.92
P2=.04 P1= 1.05

Since i have achieved P1 to be positive, calculation should stop with value in P2=0.04

I have to do this for 31 column and hence manually doing it takes long time



Please help and let me know if you have any questions..

Riz Momin