Replace 0s with blanks - IF statement

Hi this is my current IF statement.

PHP Code: 


=IF('\\ukyorw09\HR\IAC New Starter Tracking\IAC\Application\[TestGood5.xls]Master Data'!$K$2:$K$65000="Yes",'\\ukyorw09\HR\IAC New Starter Tracking\IAC\Application\[TestGood5.xls]Master Data'!N3,"") 


Where there isnt a value in the sheet its looking up it leaves the cell in this sheet as 0. Is there away to change it so it is blank???

Thnaks

For the blank cell, are you referring to cell N3? If so, try:

Please Login or Register  to view this content.

HTH

Jason

No it was just a random cell where i copied the formula from......its like that for the whole sheet????

How would i do the same when i am just lookin up a sheet directly as below -

PHP Code: 

='\\ukyorw09\HR\IAC New Starter Tracking\IAC\Application\[TestGood5.xls]Master Data'!A2 


For that, you would use:

PHP Code: 

=IF('\\ukyorw09\HR\IAC New Starter Tracking\IAC\Application\[TestGood5.xls]Master Data'!A2="","",'\\ukyorw09\HR\IAC New Starter Tracking\IAC\Application\[TestGood5.xls]Master Data'!A2) 


Jason