Hello Carole,

The ISERROR() function returns TRUE() or FALSE() depending if the argument passed to it returns an error condition. It does not return the text "TRUE". The =IF(cond,DoIfTrue,DoIfFalse) statement expects a condition that returns TRUE() or FALSE() to test.

The formula you want needs to be written:
Code:
IF(ISERROR(FIND("30_",B27,1)),D27*E$8,D27)

_________________________
Andrew Bates