Forum home » Delegate support and help forum » Microsoft Excel Training and help » - #DIV

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

- #DIV

Resolved · Low Priority · Version Standard

Reply Wed 12 Sep 2007, 16:47Delegate Deborah said...

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

#DIV

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.

For upcoming training course dates see: Pricing & availability

Reply Wed 26 Sep 2007, 15:20Trainer Carlos said...

RE: #DIV

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

Excel articles

· What Is A Sparkline And How Do They Work?
· Create An Improvised Bar Chart In Excel
· MS Excel: Excel At Making The Most Of Your Christmas
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Utilise the web's information banks with Microsoft Excel

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy