Thanks so much guys!
Thanks! I had a total brain block when I tried to figure that out late last night. Lol I still can't, something is odd with that number. You can take it straight off and get the actual gain. But all other positive numbers, you need to add 1 (ie 100%) to get the actual number, like normally is the case when you talk about something is as being x% higher than something else. Ie something that is 50% higher than 100 is 150% times 100 = 150. But the formula used in Excel should be the same for all numbers so I don't understand why it isn't the same for all numbers. Need to look into the spreadsheet and see what has happened.