Thread
:
Mod Function
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Lizz45ie
external usenet poster
Posts: 20
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.
Reply With Quote
Lizz45ie
View Public Profile
Find all posts by Lizz45ie