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