On Sun, 28 Nov 2004 20:55:50 +0000 (UTC), "Julian Campbell"
wrote:

If C Is more or less than the required balance, I want the variance figure
to be shown in another Cell (E)

Assuming your cells are in Row 1, in E1 place the formula:

=IF(D1<0,D1,"")


--ron