If function problem ... not the wanted result

You probably need a VLOOKUP table rather than a series of IF conditions. However upload the workbook and manually add the results you expect explaining whichcells are the results and which original data.

Hi,

Does this help at all?

Formula:

Please Login or Register  to view this content.

OK, so you have a bunch of suggested "therapies", let's start with "diagnosis" or may be "post mortem" analysis .
May be this will let you choose appropriate solution out of proposed.

Your formula starts with first IF:

Formula:

Please Login or Register  to view this content.

how it is evaluated by Excel:
first step:
I3=0%
it is False (almost always - unless I3 is 0 or empty, but probably there is some value, so as I said result is False)
then as opposite to what our math teacher tried to teach us, excel evaluates
False<0.6% (so result of first comparision is compared with 0.6%)
as 0.6% is numerical value, Excel will convert left side also to mumerical value to do numerical comparition. And False is equivalent to mumerical 0
so 0<0.6% is evaluared, and it is of course True.
The true part of if is executed so the final result is always -5.

If you would for some reason like to stick with your approach, you could start with:

Formula:

Please Login or Register  to view this content.

But note that in first IF you already checked that I3>=0.6% (it it was less, first condition would be true, so second and next ifs do not have to check lower limit:

Formula:

Please Login or Register  to view this content.

Hope it gives some additional insight