Forum Discussion
Conditional formatting using formula IF
I am looking to create a formula that deals with text and numbers. How can i create a formula that says if cell "E2" has "prev" and cell "M2" has "hour" then cell "N2" equals "500"?
I'm not sur...
Like
=IF(ISNUMBER(SEARCH("prev",E2))*ISNUMBER(SEARCH("hour",M2)),500,"")
in N2