Hi
I'm having a problem with a function that I can't get right.
I'm currently using the following:
=IF(E16=F16,"1","0")
This works fine in that when there is data entered into the cells, I get the correct result I require.
The problem I'm having is that I need to return a result of "0" when there is no data in cells E16 or F16. At the moment, when the cells are blank, I still get a return of "1".
Could anyone help please?
Many thanks
Mama
Bookmarks