"TammyS" wrote in message
...

"SimonCC" wrote:

...
Secondly, what tells you that Excel is saying G10 (-20) is greater than
zero? Sorry I couldn't figure that part out.

When I used the the step by step function to figure out the error, it
said
that G100 was TRUE even though G10 was -20.

Are you sure that G10 is a number, not text?
--
David Biddulph