I'm sure you know but just in case, 100%=1 so if you are testing numbers like 1,2,3 % then all of those numbers are <1 (<100%). Did you try a number like 200? I assume your formula looks something like this: =IF(D3<1,3,1)
I believe you just solved my problem. I knew what you just said but the cell with the % in it needs to be viewed as is. So i assume the easiest solution would be to change the formula to <.01. I am going to test that now.