So here is a screen shot of the worksheet:

The formula you see in the formula bar is for cell R50, which is displaying 2.

It makes no sense, Excel has been doing this to me all day, it doesn't matter what the value in the targeted cell is, the IF statement just spits out one of the possible values randomly.

**=====================**

**NEVERMIND, FIGURED IT OUT**

**=====================**