crooser100
New Member
- Joined
- Dec 2, 2009
- Messages
- 16
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
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