Hi,
I have following values.
A1 -100
B1 - either zero or blank
C1 - Formula A1/B1
When B1 is either zero or blank it gives me #DIV/0! value. Is there a way to avoid it.
Thnx
NKRA
Hi,
I have following values.
A1 -100
B1 - either zero or blank
C1 - Formula A1/B1
When B1 is either zero or blank it gives me #DIV/0! value. Is there a way to avoid it.
Thnx
NKRA
Last edited by NKRA; 07-28-2010 at 05:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks