How do I make cell A3 equal 4 if cells A1 and A2 are the same?
For example if cell A1 and A2 have a X in it, then cell A3 =4
or if cell A1 and A2 are blank then cell A3 =4
As long as the cells match, cell A3=4
If cells do not match then cell A3 =0

Yes, that worked. But what would i have to do to make cell A4 be 4 if cell
A1, A2 A3 are the same and have cell A4 be 0 if A1 A2 A3 do notr match in any
order?

If you want to know how the Excel AND function works, look it up In Excel
help. [The same applies for every other Excel function except DATEDIF.]

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.