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.