The following code makes me nervous as I don't know how it works (it does 'seem' to work).
In Cell U6 in Sheet calculator I wand to replace any Div 0 error with 0 itself.
Looking for insight on how the bold line below works:
Also there is only one End If !?
Please Login or Register to view this content.
Last edited by intothewild; 06-09-2014 at 02:17 AM.
Non VBA solution.
=Iferror(j6/g6,0)
or
=if(g6=0,0,j6/g6)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
A simple formula should do the job but if this a part of a code you could try something like this.
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
CVErr(xlErrDiv0) returns the actual error value for a division by zero error. You only need one End If because only one of the If clauses spans multiple lines - there are two forms of If clause. The one-liner:
and the multi-line:Please Login or Register to view this content.
Does that help?Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
Yes! Thanks!Originally Posted by romperstomper
CVErr(xlErrDiv0) returns the actual error value for a division by zero error. You only need one End If because only one of the If clauses spans multiple lines - there are two forms of If clause. The one-liner:
and the multi-line:Please Login or Register to view this content.
Does that help?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks