Reply to thread

Message: [QUOTE="LinLin, post: 3797251"] Hello Teethless and gary's students That formula will always run into problems with neg values. So imagine my original data was for Income. I earned 100, I expected to earn 200, so I under earnt 100 (50% below budget, which works with the formula) BUT If my earnings went negative (I had to give all the income back!) AND I expected to return earnings so I had a negatuve budget too, this is my situation: earned -100, expected to earn -200, variation is -100 AND I have OVERearned, so my %variance is actually +100% So perhaps the formula has to do some comparison to see if a number is <0, 0 or >0, and then do its thing, rather than assign a minus to the formula automatically? It's been very helpful so far, as you can see, it's a hairy one! thanks! [/QUOTE]