If Iserror or 0 formula....

[crooser100]

Hi there


I’m trying to build a formula to say: if iserror or 0, then return “”.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Here’s what I’ve got so far..

<o></o>
=IF(OR(ISERROR('[TEST KPI.xls]Input'!$K$7),('[TEST KPI.xls]Input'!$K$7=0)),"",('[TEST KPI.xls]Input'!$K$7))

<o></o>
It returns “” when there’s no number, but when there’s an error it shows the error??

What changes do I need to make?


Many thanks
Jo

 

[VoG]

Try

=IF(OR(ISERROR('[TEST KPI.xls]Input'!$K$7),'[TEST KPI.xls]Input'!$K$7=0),"",'[TEST KPI.xls]Input'!$K$7)

 

[WaterGypsy]

when you say 'it shows the error', what exactly are you seeing?

 

[crooser100]

Great thanks!!!