Home > Support > Software

Excel FAQ's

. How can I get rid of the #DIV/0! that I get when I have a formula that divides one cell by another cell.

. This result occurs when the cell you are dividing by contains a 0 or is empty. Often when we copy formulas they involve cells that do not yet have values, hence #DIV/0!. The way to avoid this is to check for a value of 0 before performing the calculation. Instead of 
=F7/E41
Use an If statement to check the value of E41
=If(E41<>0,F7/E41,"")
This formula translates as If E41 is not 0 then divide F7 by E41, otherwise show a blank cell.

. I don't have Excel but someone wants me to look at a spreadsheet they have sent me. Is there any way I can do that?

. Yes, Microsoft has an Excel spreadsheet viewer available for download at http://www.microsoft.com/downloads/details.aspx?FamilyId=C8378BF4-996C-4569-B547-75EDBD03AAF0&displaylang=en but you will only be able to view or print the sheet, not change it. You can also install the free program Open Office which is compatible with Word, Excel and PowerPoint through the Office2003 version and with Office 2007 if the files have been saved as .doc, .xls and .ppt.

Search this site with

¶Questions or problems regarding this web site should be directed to webmaster at deltacomputing.com.¶
Privacy Policy
Last modified: 12/15/11

.
This work is licensed under a Creative Commons Attribution-NoDerivs 2.5 License.
Privacy Policy