Excel Reference showing 0 for blank cells 1

[ruthiea]

Hi there,

I have a simple workbook consisting of lots of individual worksheets and a summary sheet.

The summary sheet simply pulls data off the other sheets - i.e. ='sheet_name'!A1

This works fine but if the source cell is blank the summary sheet puts a 0 in instead. Does anyone know of a simple way to return a null value?

Cheers

 

[KenWright]

=if(your_link="","",your_link)

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[ruthiea]

Thanks Ken, that sussed it!

 

[KenWright]

You're welcome

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------