Hi there,

I have given the cell AL5 the following basic formula...
=AF1

However, when there is no item in AF1 it returns the value "£0", or if I format AL5 to 'general' then it returns "0".

How do I get it to return a blank cell when AF1 is blank?

Any help appreciated.