Dear All
I am facing
0/0 = #DIV/0!
500/0= #DIV/0!
0/500= #DIV/0!
how can i avoid this for the same calculation.
regards
Roofi
Dear All
I am facing
0/0 = #DIV/0!
500/0= #DIV/0!
0/500= #DIV/0!
how can i avoid this for the same calculation.
regards
Roofi
Last edited by roofi; 02-23-2016 at 08:10 AM.
Abdul Rouf Roofi
If this is in excel formula use IFERROR. If this is in VBA then use On Error GoTo statement.
=IFERROR(A1/B1,"")
0/500 will give you an answer "0" not an error.
If(b1=0,0,a1/b1)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks