Help with a lookup formula

[bankerlady]

I have a lookup formula written in a cell to give me a value based on a percentage of goal in the previous cell. My question is....if the percentage of goal is a minus because the actual was a minus number, then where do I put my minus in my formula ?? Here is my formula:

=LOOKUP(I29,{0,0;0.01,1;0.6,2;0.85,3;1,4;1.15,5})

In my example my value in I29 is -9.53% and I want it to return a 0% of goal in the next column.

Thanks for your help.

 

[Aladin Akyurek]

=LOOKUP(I29,{-9.99999999999999E+307,0;0.01,1;0.6,2;0.85,3;1,4;1.15,5})