Hello
welcome to the forum....
Yes your problem is quite serious....it happens many times that we have to duplicate the formula just to check a zero...
So here is a simpler method--
I have made a user defined function--
Just go to Developer tab>>Visual Basic>>insert>>module>> and paste the following code
Code:-
Now type in the formula =ifzero(complexformula)
it will return a blank if a zero is there...
hope it helps
Regards
Sourabh
//<<<---If you like my suggestion then you can thank me by pressing the Add reputation button below....
//
//
/
Bookmarks