Hi all,
I was wondering if I could get some help. I am using the following formula to calculate if two numbers match and then return a specific statement. The problem I have is when both cells are blank it returns "agree" or "disagree" if one is blank and the other is not. However, I want it to ignore the calculation and return a blank if either cell is blank. I have seen a way to do this, but none of these methods allow me to return a specific statement.
#=IF(F2=G2,"Agree","Disagree")#
Any help would be greatly appreciated.
Thanks!
Bookmarks