I have a mystery that has me really perplexed. I am trying to subtract 2 percentages. The result of that formula will be used in a Vlookup formula. The results I get are strange, in that if I change a variable in the subtraction calculation the new result (which does appear in the Vlookup table) does NOT return a value yet an error.
My only thought is that it is formatting; however, I have created new files, and have changed formats several times trying to dissect this problem.
I have attached a very good example of this. By changing cell A13 (red) to anything but 8 or 10 will not bring back the right results.
Can anyone help me with this mystery?
