Need a formula

enelson81

New Member
Joined
Dec 23, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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

=IF(B8=G8,"Yes","No")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,056
Messages
5,569,953
Members
412,299
Latest member
agentless
Top