Thank you very much, I have been trying to get it to work for two days! Thanks Again Don ------------------------------ Date: Sat, 18 Jan 2003 23:15:50 -0500 From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> Subject: [mso] Re: Excel Formula Divide by zero error, please help Just missing a few parentheses, Don...this one should work for you: =IF((ISERROR((G2*H2)/F2)),"",((G2*H2)/F2)) Linda Publisher ~ ABC ~ All 'Bout Computers Owner ~ Linda's Computer Stop http://personal-computer-tutor.com FREE MS Office eBook Tutorial http://personal-computer-tutor.com/library.htm -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Donald C. Smith Sent: Saturday, January 18, 2003 9:55 PM To: Mso-Microsoft Office Newsgroup (E-mail) Subject: [mso] Excel Formula Divide by zero error, please help I have this formula in an Excel Worksheet, hoping it would not show a divide by zero error, but it does. The cells are empty until I enter information and I don't want the Divide by zero error running down all blank columns. Hoping someone can explain what I must do. I thought that was what ISERROR was for, unless I have the format wrong. Thanks Don =IF(ISERROR(G2*H2)/F2,"",(G2*H2)/F2) ------------------------------ ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************