Re: [sc-dev] Return 0 on Search Instead of Zero

Hi Leonard, On Wednesday, 2008-11-26 23:37:00 +0200, Leonard Mada wrote: I just noticed the following formula in one of the issues: =IF(AND((ISERROR(SEARCH(Pass,$F8))), (ISERROR(SEARCH(Warn,$F8))), (ISERROR(SEARCH(Closed,$F8,0,1) IIRC we already mentioned the to be

Re: [sc-dev] Return 0 on Search Instead of Zero

Hello Eike, Eike Rathke wrote: Hi Leonard, I just noticed the following formula in one of the issues: =IF(AND((ISERROR(SEARCH(Pass,$F8))), (ISERROR(SEARCH(Warn,$F8))), (ISERROR(SEARCH(Closed,$F8,0,1) IIRC we already mentioned the to be implemented IFERROR()

[sc-dev] Return 0 on Search Instead of Zero was Informing users about ODFF was [sc-dev] Rebasing CWS odff05

Hello everyone, I just noticed the following formula in one of the issues: =IF(AND((ISERROR(SEARCH(Pass,$F8))), (ISERROR(SEARCH(Warn,$F8))), (ISERROR(SEARCH(Closed,$F8,0,1) And this only because SEARCH() returns an ERROR if the string is not found.