Hello everyone! I'm stuck and could use some help from someone more advanced than I!
I am in a situation where I have a column that I need to either report a 1 if it equals another column, otherwise it is a zero. I have that part down quite nicely, but I also need the formula to return a zero if the deciding cell is blank.
For example;
=IF(E2=K2,1,0) is the formula I have now
But I also need it to return a 0 if K2 is blank...
Please help?
Thanks!
Casey Craig
Washington, DC
Bookmarks