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.


You could eliminate the MOD() function:

=((H3-INT(H3*50)/50)*100)0.5