[mso] Re: Excel Formula Divide by zero error, please help
- From: Wilson Baptista Junior <wilson@xxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sun, 19 Jan 2003 09:35:07 -0200
Hi Donald,
your formula lacks a pair of parenthesis; try:
IF(ISERROR((G2*H2)/F2),"",(G2*H2)/F2)
But it would be simpler just to test F2 for being zero, as in:
IF(F2<>0,(G2*H20/F2,"")
Keep in mind that having your formula put a space in the cell can lead to
another kind of error in Excel, if this cell is then used for other
calculations. It would be better to put in a zero instead of a space.
Best,
Wilson
At 21:55 18/01/03 -0500, Donald C. Smith wrote:
>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
>*************************************************************
*************************************************************
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:
