Lizz45ie wrote:
The Mod function returns #Num! error value. Here is my formula:
=MOD(H3*100,2)0.5
The above formula is used in my net value column. If the Net value is above
$3 million I get the #Num! error.
An interesting limitation/undocumented feature/bug of the MOD function.
See for explanation and work-arounds:
http://excel.tips.net/Pages/T003302_..._Function.html