Thread: Mod Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lizz45ie Lizz45ie is offline
external usenet poster
 
Posts: 20
Default Mod Function

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.