|I'm not quite sure what you are trying to do with that formula. It's the Concatenation Operator (&) that confuses me. I know what it does, but I don't know why you are using it.|
The 2 conditions for your IF's are >.25 and <.25.
I tried these actual values, and got the associated results:
10 .24 00.25
11 .25 00
12 .26 0.5
I should note that the returned values are Text values because of the Concatenation Operator. Depending on what you plan to do with those values, the fact that they are Text may cause problems.
What exactly are you trying to do with this formula?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.