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!