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.
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
