compare 2 cells, put "result" in 3rd??

  • Thread starter Thread starter aapp81
  • Start date Start date
A

aapp81

hi, this is my first post but i've been a long time looker...
anyway, i need to compare cells in column a, lets say, to column b. an
say, if a5 matches b5 then c should say "E" else, it should say "A".
also, i only want to compare the same "row" of the columns - meanin
only a2 to b2 or a46 to b46 not a6 to b12 and so on.
any help would be great!
thanks..
 
Hi Aapp, this is a fairly straightforward thing

=if(a5=b5,"E","A")

will do the job, and is even easier if you want to compare the same row
only.

the way you wrote the sentence is in fact the same way you write this
formula out. if a5 matches b5 (if(a5=b5) then "E", else "A" ("E","A")
 
thanks a lot! formula works great - i don't believe it's this simple..
i've tried so many attempts and i guess my problem was that i wa
stating in the formula that i want the formula in the cell i wa
writing it..
 
Hi,

You can use a simple IF/THEN statement for column C:

=IF(A5=B5,"E","A")

Then copy this formula to the other cells in column C.
Excel automatically adjusts the row reference, i.e. the
formula for C6 will look like this:

=IF(A6=B6,"e","a").

Good luck!
 
Back
Top