• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

COmparing cells for result

Aspur

New Member
Hi there, I'm trying to right a forumla that will compare two cells. They cells have data that in combination will produce an "answer" . SOmething like this: if cell D1="Cur" and cell E10="Active" then return "Current". I've tried many ways, but I'm just missing something where it's not working. Any help appreciated.
 
Expected results should be if cell (1) = "CUR" and cell (2) ="Active" then result is Current
 
Back
Top