Check my excel here : https://docs.google.com/spreadsheets...it?usp=sharing
I need to set a formula in colomn D, whereas it will be notably as fixed if 2 colomn, somewhere ranged in E to I, has been typed in as "fixed".
For now I know only a formula, whereas if 1 colomn has been typed in as "fixed" with formula "=IF(COUNTIF(E2:I2,"*fixed*")>0,"FIXED, Please Check","NOT FIXED, Please check ilham's coment and/or fix it!")
Please tell me the right formula.
Bookmarks