| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching cell formula
I am looking for a formula that if the cell A1 and A2 match then cell A3 will
be 4 if they do not match then 0 example: A1 has YES and A2 has YES then cell A3 will be 4 IF both cells are blank the A3 would say 4 A1 has YES and A2 has NO then cell A3 will be 0 A1 has NO and A2 has YES then cell A3 will be 0 Is this possible? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
matching cell formula
In cell a3 type =if(a1=a2,4,0)
deepokerman wrote: I am looking for a formula that if the cell A1 and A2 match then cell A3 will be 4 if they do not match then 0 example: A1 has YES and A2 has YES then cell A3 will be 4 IF both cells are blank the A3 would say 4 A1 has YES and A2 has NO then cell A3 will be 0 A1 has NO and A2 has YES then cell A3 will be 0 Is this possible? Thanks -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200910/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
matching cell formula
What an amazing coincidence! Someone asked the same question yesterday, and
it was answered here. http://groups.google.co.uk/group/mic...c4a45be1246af# -- David Biddulph "deepokerman" wrote in message ... I am looking for a formula that if the cell A1 and A2 match then cell A3 will be 4 if they do not match then 0 example: A1 has YES and A2 has YES then cell A3 will be 4 IF both cells are blank the A3 would say 4 A1 has YES and A2 has NO then cell A3 will be 0 A1 has NO and A2 has YES then cell A3 will be 0 Is this possible? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula: copy/concatenate cell contents matching condition | Excel Discussion (Misc queries) | |||
| find cell with matching text, then reference cell in same row | Excel Worksheet Functions | |||
| Matching Formula ?? | Excel Worksheet Functions | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
| Matching formula - i need help | Excel Discussion (Misc queries) | |||
Linear Mode
