IF(FIND Function with OR
I am trying to build a formula that searches in a column for a certain word using the IF(FIND formula but I would like to add in an OR to that. So I would like to use this function: =IF(FIND("Design", [Project Description]4) > 0, [Estimated Hours:]4, "") which works great, but add in other words such as Graphics to it. So the formula would search for the word design or the word graphics and if it finds it, then return the data from the Estimated Hours column. I cannot seem to get it right so including the formula that I know does work, but asking how I would build an OR to this formula.
Help Article Resources
Check out the Formula Handbook template!