- #DIV

Resolved · Low Priority · Version Standard

#DIV

Deborah has attended:
Excel Advanced course
Access Introduction course
Access Intermediate course

by - delegate Deborah [2 posts] (2007 Sep 12 Wed, 16:47) Reply

How do I get rid of #DIV if I am multiplying a cell with no value by an exchange rate. e.g. blank x 2.0191 = #DIV.

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 2 Tue	Bloomsbury	0	FULL
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
Full Schedule: See all 110 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: #DIV

by - trainer Carlos gold contributer [479 posts] (2007 Sep 26 Wed, 15:20) Reply

Deborah

#DIV0 SHOULD ONLY appear when a number is divided by 0 or a blank.

Click on the cell with the #DIV0 and do an Error check.

In the top left corner of the cell there should be a green simbol. Point to it and an erreo icon should appear. Do a trace error and see if the formula has a division by 0 anywhere.

Carlos

· Advanced Excel Training - takes you to the next level
· How to check for and reduce errors in Microsoft Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· How Excel Training Can Improve Your Company's Sales Process
· Identifying Suitable Candidates For VBA For Excel Training

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

Rate this page: