[mso] Re: Excel Formula Divide by zero error, please help
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sat, 18 Jan 2003 23:15:50 -0500
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
*************************************************************
Other related posts:
