Forum Discussion
Margin Divisible by 5?
Hi, I am looking to find a calculation that will tell me whether an item was sold at a margin divisible by five or not. i.e. ..., 35%, 40%, 45%, 50%, ... etc. I figured it would be simple using ...
Sale Prices of $0.00 were creating -infinity values which was screwing it up. I stacked another IF statement on top of the other, saying IF([Sale]=0, IF(MOD([Margin], .05) = 0, "True", "False"), "False")
Hi,
I am looking to find a calculation that will tell me whether an item was sold at a margin divisible by five or not. i.e. ..., 35%, 40%, 45%, 50%, ... etc. I figured it would be simple using the MOD function. I tried each of the following
DivisibleBy5 = IF(MOD([Margin], 0.05) = 0, "Yes", "No")
DivisibleBy5 = IF(MOD([Margin] * 100, 5) = 0, "Yes", "No")
Each give me an error saying "An argument of function 'MOD' has the wrong data type or the result is too large or too small".
My [Margin] is a decimal number and classified as such. Any idea what's going wrong? Any other ways to get the result I'm looking for?
Thanks,
Ryan
Phil_Seamark
Microsoft Employee
Microsoft EmployeeTry creating a calculated column that just uses the inner formula
Eg. Column = mod ([margin] , 5)
And what does that show?
Eg. Column = mod ([margin] , 5)
And what does that show?