Mon 9 Jul 2007, 15:58Delegate Peter said...
Peter has attended:
Access Introduction course
Excel formatting/Formular
When creating a formular dividing a number into 0 result is often Div0, how can this be formatted to produce a 0.
Tue 10 Jul 2007, 12:40Trainer Anthony said...
RE: Excel formatting/Formular
Hi Peter. You need to use the IF function to achieve this. Lets say cell A1 contains "2" and A2 contains "0". Put the following formula into A3:
=IF(A2=0,"0",A1/A2)
The IF function looks at A2. If it contains a "0" value it puts a "0" into cell A3. If it doesn't contain a "0", it puts the result of A1/A2 into A3. Voila!
