Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    9 years ago

    MattAllington

     

    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")

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

Please check the data type of the column [Margin]. If it is text, the formula will return #ERROR and you should change it to decimal number.

 

Thanks,
Yuliana Gu