F Feejo Jan 3, 2008 #1 I remove error from option, and error show again Div/0. When I try to click Error checking Excel is not responding.
I remove error from option, and error show again Div/0. When I try to click Error checking Excel is not responding.
J Jon Peltier Jan 3, 2008 #2 I remove error from option I don't know what you mean. Adjust your formula: =IF(B1<>0,A1/B1,"") =IF(B1<>0,A1/B1,0) Put something sensible in the last position in the IF() statement. - Jon
I remove error from option I don't know what you mean. Adjust your formula: =IF(B1<>0,A1/B1,"") =IF(B1<>0,A1/B1,0) Put something sensible in the last position in the IF() statement. - Jon
F Feejo Jan 3, 2008 #3 I just need to wait 5 minutes. Jon Peltier said: I don't know what you mean. Adjust your formula: =IF(B1<>0,A1/B1,"") =IF(B1<>0,A1/B1,0) Put something sensible in the last position in the IF() statement. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ Click to expand...
I just need to wait 5 minutes. Jon Peltier said: I don't know what you mean. Adjust your formula: =IF(B1<>0,A1/B1,"") =IF(B1<>0,A1/B1,0) Put something sensible in the last position in the IF() statement. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ Click to expand...
