IF cell value >0, enter that value, if cell value is #DIV/0!????

[Sorcha]

Hello. I want to use IF forumla to say: IF D16>0, then enter the value in D16. If there is no value in D16, I want to enter the value from another cell, D20.

But my problem is that when there is no value in D16, it reads #DIV/0!, because D16 itself is the result of another calculation (D3/D14). Is there any way that I can tell Excel not to worry if it finds #DIV/0!, just go ahead and enter the value from D20 instead?

Thanks!

[NBVC]

Try

=If(ISERR(D16),D20,if(D16>0,D16,D20))

You can also try getting rid of the #DIV/0 error by revising formula in D16 to : =IF(D14=0,0,D3/D14) then you can use formula; =If(D16>0,D16,D20) for your original question here and have a tidier looking sheet.

[Sorcha]

Thanks! That worked a treat!

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save