Number Format with Macro

[Lizz45ie]

I am using a macro to sum some values; if the summed value is greater than
2.5M then the macro returns #NUM!. Here is what I'm using to sum the values:

"=MOD(H3*100,2)>0.5"

 

[Mike H]

Hi,

This bug is well documented and Microsoft offer a workaround here

http://support.microsoft.com/?kbid=119083

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Lizz45ie]

Mike,

I looked at the suggested site for the workaround. I tried a couple version
of my formula; the macro crashed.
Sample formula:

=MOD(MOD(H3*100,2)>0.5)

=H3(INT((H3*100,2))>0.5