Formula Help

[MarkAndrews]

For whatever reason, this formula returns an error on '""'
(or the true part)

Any idea's?

TIA

=IF(isblank('[Complaint Log 2006.xls]September 2006 - May 2007'!$DT$4,"",'[Complaint Log 2006.xls]September 2006 - May 2007'!$DT$4)

 

[Norie]

Mark

Isn't it just a missing closing bracket for the ISBLANK?

=IF(ISBLANK('[Complaint Log 2006.xls]September 2006 - May 2007'!$DT$4),"",'[Complaint Log 2006.xls]September 2006 - May 2007'!$DT$4)

 

[hatman]

=IF(isblank('[Complaint Log 2006.xls]September 2006 - May 2007'!$DT$4),"",'[Complaint Log 2006.xls]September 2006 - May 2007'!$DT$4)

Try adding in the close paren for the Isblank() function... it should have given a syntax error, though

 

[Cbrine]

=IF(isblank('[Complaint Log 2006.xls]September 2006 - May 2007'!$DT$4),"",'[Complaint Log 2006.xls]September 2006 - May 2007'!$DT$4)

You were missing a bracket in your ISblank Check.

HTH
Cal

 

[MarkAndrews]

DOH!! Thanks Guys

I've had a very traumatic week.....