|I want to compare two cells that have a formula in them. If the values are equal I want it to be 0.5. If the first cell is larger than the second I want it to be 0. If it is smaller I want it to be 1. If either cell being compared I want it to be blank. The formula I came up with but it does not give a 0.5 value if they are equal. This is what I tried:|
I think the problem may be because the value I want to compare is formatted for no decimal places but it seems to want to compare the decimal value so it does not appear as equal values. I only want to compare the non-decimal value.