E enelson81 New Member Joined Dec 23, 2005 Messages 2 Dec 23, 2005 #1 I need a formulat for the following; I am comparing data in two cells b8 & g8 and would like cell k8 to return a value of yes if these two cells = and no if not. Anyone help on this? Thanks and happy holidays -Eric
I need a formulat for the following; I am comparing data in two cells b8 & g8 and would like cell k8 to return a value of yes if these two cells = and no if not. Anyone help on this? Thanks and happy holidays -Eric
Aladin Akyurek MrExcel MVP Joined Feb 14, 2002 Messages 85,201 Dec 23, 2005 #2 enelson81 said: I need a formulat for the following; I am comparing data in two cells b8 & g8 and would like cell k8 to return a value of yes if these two cells = and no if not. Anyone help on this? Thanks and happy holidays -Eric Click to expand... =IF(B8=G8,"Yes","No")
enelson81 said: I need a formulat for the following; I am comparing data in two cells b8 & g8 and would like cell k8 to return a value of yes if these two cells = and no if not. Anyone help on this? Thanks and happy holidays -Eric Click to expand... =IF(B8=G8,"Yes","No")