Hello,
I am trying to add Cell C3 into this equation also. The reason is I don't get the #DIV/0! error when the cell is empty. I know that =IF(A3=0,"" will give me a blank cell instead of a #DIV/0! but I don't know how to add two cells into that equation
=IF(A3=0,"",A3/C3)
=iferror(a3/c3,"")
Hi,
Check the below formula and hope this will help :
=IF(OR(A3=0,C3=0),"",A3/C3)
Regards,
PAresh J
Click on "* Add Reputation" as a way to say thanks
Thank you so much I learned something new today
May be this
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks