Getting a #Value instead of a blank cell.

[Lizabeta]

D4 is linked to a cell in 'anotherworkbook'. It's also part of a formula in 'mainworkbook'. Not wanting to get an error, I tried:

=IF(D4=0, "", G4/D4)


D4's value is:

='[anotherworkbook.xls]Sheet1'!F5

But when anotherworkbook.xls, has nothing input for Sheet1, F5... then I get a #Value returned instead of the "" blank spot I wanted.

How should I fix this to return a blank cell instead of #Value?

[daddylonglegs]

Try

=IF(ISERR(G4/D4),"",G4/D4)

[XL GURU]

Hi,

use this formula

=IF(ISERROR(G4/D4),"")