I have this function:

=IF(B1="","",LOOKUP(COLUMNS($A$1:B1)-COUNTIF($A1:B1,"="),{1,2,3,4},{0.2,0.19,0.18,0.17} ))

I'm wanting to modify it in such a way that when I put 0(zero) on A1, the result on B2 would still be 0.2 instead of .19. For some reason, every time I put 0 on A1, the function is recognizing it as a number.

I attached the excel screen shot.

Thanks.