Division by zero

**Rebelle** · Rebelle, March 2nd, 2010 12:37 PM

Hi All,

How should I handle cases where I might have zero...getting the following error:

Code:

Microsoft VBScript runtime error '800a000b' 
Division by zero

field that contains zero:

Code:

sActThreeMoAgo1 = rs("ActThreeMoAgo")

**richyrich** · richyrich, March 2nd, 2010 01:18 PM

Maybe something like?

Code:

If sActThreeMoAgo1 = 0 Then

**Rebelle** · Rebelle, March 2nd, 2010 03:01 PM

Hey RR,

But is there no way to make the following equal display 0?

Code:

0/8

sActThreeMoAgo1/sAnotherFieldName

**richyrich** · richyrich, March 2nd, 2010 04:35 PM

Originally Posted by Rebelle

Hey RR,

But is there no way to make the following equal display 0?

Code:

0/8

sActThreeMoAgo1/sAnotherFieldName

I don't think so. Dividing anything by zero will always generate an error. The only way would be to suppress the errors (On Error Resume Next) and then define a variable as zero and make the value the division calculation. I think that would then leave it as zero.

**micky** · micky, March 3rd, 2010 03:48 AM

Ya, if there is division involved, then you must check the value (with which dividing) for zero. If its not 0, only then divide.

So if its 0 then display 0.

**Rebelle** · Rebelle, March 3rd, 2010 10:14 AM

Thanks RR and Micky,

will try something like you suggested...

Code:

if sActThreeMoAgo1 > 0 then
sMain = sActThreeMoAgo1/sAnotherFieldName
else
sMain = "0"
end if

Thread: Division by zero

LinkBack

Thread Tools

Display

Division by zero

Bookmarks

Bookmarks

Posting Permissions