2 Replies Latest reply on Feb 13, 2015 6:55 AM by Madeline Coyne

    Rounding to nearest 0.5

    Madeline Coyne

      I have tried many of the formulas on this forum Re: How do I round a decimal up to the next whole integer? but none have helped solve my problem. My issue is that my data is all fractions and in certain cases the total ends up being 0.04. I uses these number to create Cost per formulas so in many cases it will generate a Cost Per which is higher than the spend since it's being divided by a fractions.

       

      I need a formula for this to just return null but if I try a simple if CpBind > Media Spend then 0 else CpBind end I am prompted with an error.

       

      Thank you