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 sure if that makes sense or not, but that is the best way for me to simplify it.
2 Replies
- Thank you! That formula worked perfectly.
Like
=IF(ISNUMBER(SEARCH("prev",E2))*ISNUMBER(SEARCH("hour",M2)),500,"")in N2
