How do I make a copy or a back up of a workbook that will not fit on a single 3.5 disk, so that I may transfer from home to office?
I run into this a lot. I save the file to disk, then use the shareware utility WinZip to copy the Excel file into a .zip file. Copy the Zip file to a 3.5 disk, bring it home, copy the zip file to my hard drive and then use WinZip to extract the files. I am usually able to fit 3-4MB of files into a Zip file which will fit on a 3.5″ disk. I am trying to get the percentage of two cells by dividing one cell into the other. Some of the time both cells might have a Zero in each. Therefore the DIV\0error shows up in my spreadsheet in the result cell that I have the formula in. How can I get it to recognize 0 divided into 0 so I can get a 0 answer in my total column not the error message? This seems like an incredible pain, but I have to use it all of the time. If your spreadsheet is set up with the numerand in column A, the divisor in B, and in C you are trying to calculate A/B, then you would enter this formula in cell C2: =IF(B2=0,”NA”,A2/B2) At my job, we use NA to indicate that a number d
Related Questions
- How do I make a copy or a back up of a workbook that will not fit on a single 3.5 disk, so that I may transfer from home to office?
- Does George Mason University have virus protection software? How can I get a copy for my computer (office computer or home computer)?
- How to I transfer files from another computer too large to fit on a floppy disk?
