#DIV/0 value

building reports desktopintelligence
1

Hi All,

How to convert #DIV/0 to 0?
when i calculate variance% it givers #DIV/0 where (A-B)/B=(0-0)/0

Thanks in advance.

nickie :us: (BOB member since 2010-02-16)

2

Hi,

Instead of (A-B)/B use:

=If <B><>0 Then (<A>-<B>)/<B> Else 0

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

That Works Thanks A lot…!!! :wave:

nickie :us: (BOB member since 2010-02-16)