I'm trying to make an IF formula to detect if there's any asterisks in the worksheet. =IF(WORKSHEET RANGE," * DOES NOT MEET SPECIFICATIONS ","") That way if there is one it will display *DOES NOT MEET SPECIFICATIONS" and if there isn't one it displays nothing.