I have created the table below to vlookup a % but I can't seem to figure out
how to get less than 0 to work for me. Can anyone fill in the below 0 lookup?

-0.01 <0
0.00 0 - 9.9
0.10 10 -19.9
0.20 20 - 29.9
0.30 30 - 39.9
0.40 40 - 49.9
0.50 50 - 59.9
0.60 60 - 69.9
0.70 70 - 79.9
0.80 80 - 89.9
0.90 90 - 99.9

Nikki,

Posting the same vague question in a new thread in another forum won't help
you. Go back to your original thread in 'Worksheet functions' and clarify
your question there.

Mike

"Nikki" wrote:

I have created the table below to vlookup a % but I can't seem to figure out
how to get less than 0 to work for me. Can anyone fill in the below 0 lookup?

-0.01 <0
0.00 0 - 9.9
0.10 10 -19.9
0.20 20 - 29.9
0.30 30 - 39.9
0.40 40 - 49.9
0.50 50 - 59.9
0.60 60 - 69.9
0.70 70 - 79.9
0.80 80 - 89.9
0.90 90 - 99.9