[mso] Excel Formula Divide by zero error, please help
- From: "Donald C. Smith" <DCSmith@xxxxxxxxxxxx>
- To: "Mso-Microsoft Office Newsgroup (E-mail)" <mso@xxxxxxxxxxxxx>
- Date: Sat, 18 Jan 2003 21:55:21 -0500
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
*************************************************************
Other related posts:
