In your sample formula it looks like you are checking to see if S6 is a blank
cell, if so enter a 0. you could try =IF('Account Entry'!S6=0,"0",'Account
Entry'!S6+S5)


"Simon Lloyd" wrote:


Hi all, I have a formula that looks at the cell value on one sheet and
adds it to the previous value on the original sheet, my problem is
this....where this formula appears it shows the last summed value so in
this case from S6 down to Sxxx it will show the value £813 because this
is the last value it added, in the formula below i would like it to
state that if 'Account Entry'!S6 is zero then dont calculate S6+S5 just
show zero! is this possible in a formula? =IF('Account
Entry'!S6="","0",'Account Entry'!S6+S5)

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=551646