I have the following formula: =IF(COUNT(D11,H11)=2,(H11-D11)/D11,"") but I'm running into the problem where #DIV/0! error occurs when D11 is 0. How can I add to this formula so that if D11 is 0, the formula returns a blank cell?
I have the following formula: =IF(COUNT(D11,H11)=2,(H11-D11)/D11,"") but I'm running into the problem where #DIV/0! error occurs when D11 is 0. How can I add to this formula so that if D11 is 0, the formula returns a blank cell?
Hi ecrolley,
You can update the formula as =iferror(<your formula>,""). Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Figured it out!
=IF(D11=0,"",IF(COUNT(D11,H11)=2,(H11-D11)/D11,""))
Thank you, DILIPandey!!
You are welcome.. and it's good that you yourself have figured it out.. cheers to you
Suggest you to mark this thread as [SOLVED].. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks