An equals formula that doesn't return a blank cell

**stanja** · 08-30-2009, 03:10 PM

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.

**martindwilson** · 08-30-2009, 03:14 PM

if(af1="","",af1)

**mikerickson** · 08-30-2009, 03:14 PM

You could use
=IF(AF1="","",AF1)

or
=AF1&""

**stanja** · 08-30-2009, 03:22 PM

Thanks for the help, I used

=AF1&""

**daddylonglegs** · 08-30-2009, 03:37 PM

You just need to be a little careful using that formula......

If AF1 contains a number then that formula returns the result as text....which could cause you problems if you include it in a SUM function (text is ignored by SUM) or similar.....