Try

=LOOKUP(N(B32),{0,0.96,0.97,0.98,0.99,1},{0,0.03,0.035,0.04,0.045,0.05})/$G$13

Please have a read of the forum rules regarding thread titles, in my opinion, your title falls between 'anticipated solution' and 'poor thread title'.

If you look at the formula above, and the suggestion from Snuggles in post #3, there is no use of the IF function in either.

I would suggest that you change your title to something more meaningful, however, I'm not making it a formal moderation request.