Need help with If formula

I need a cell to return display a rating if another cell contains a value between different ranges. Ex: if cell A is 0-1 B is 5, 1-2 B is 4 etc. I used an if formula and it worked just fine, the only problem is that since i have it set up to display a 5 if the cell is between 0-0.5 it displays a 5 when there is nothing entered. It is registering the cell as a zero when it is empty. I want the cell to remain blank if nothing is entered in the other one. I tried Isblank, and just tacking on another if function but neither have worked. Here is the formula.

=IF(N39>=5,"1",IF(N39>=4,"2",IF(N39>=2,"3",IF(N39>=1,"4",IF(N39>=0,"5",IF(ISBLANK(N39),""))))))

I've also tried:

=IF(N39>=5,"1",IF(N39>=4,"2",IF(N39>=2,"3",IF(N39>=1,"4",IF(N39>=0,"5",IF(N39,"",""))))))

Thanks in advance.

I'm pretty inexperienced if ya can't tell.

You were on the right track. The reason ISBLANK wasn't working is that it was too late in the formula. By default, Excel will see blank and zero as the same thing so it was determining that N39>=0 was true and stopping the formula at that point.
By moving ISBLANK to the beginning, the formula will stop at that point if it's blank and proceed to the last function only if it's actually zero.

Please Login or Register  to view this content.

Originally Posted by Larena

You were on the right track. The reason ISBLANK wasn't working is that it was too late in the formula. By default, Excel will see blank and zero as the same thing so it was determining that N39>=0 was true and stopping the formula at that point.
By moving ISBLANK to the beginning, the formula will stop at that point if it's blank and proceed to the last function only if it's actually zero.

Please Login or Register  to view this content.

It worked! Thank you so much.