Hi,

The problem is the tick because I have no idea how you put it there and
there are several ways. So this formula in F5 will do what you want if you
substitute the word tick for whatever character you are using.

=IF(E5="tick",0,C5)

Mike

"whaler" wrote:

Hi - I have a spreadsheet which I record all my monthly outgoings in.

I put a tick in column E against each amount when it's come out of my
account. Can anyone tell me if there is a way of getting column F to read £0
when I've put the tick in column E?

I know it's something along the lines of 'if E5 has an a in it, F5 = 0' but
also want F5 to show the amount in C5 if there is no a in E5.

Hope this makes sense and someone can help!