I want to make a formula as follows.
suppose active cell is c1. and if a1=b1 and also a2=b2, then result should be yes otherwise no. I tried =if(a1=b1,if(a2=b2,"Yes","No")), now if a1=b1, then if a2=b2 or a2<>b2, it works and gives the correct result, but when a1<>b1, it gives false.
Please help
2007-05-31 05:47:26 · 5 answers · asked by ankit m 1 in Computers & Internet ➔ Software
Ok, so for cell C1, if A1=B1, and if A2=B2, then result should be YES, else NO.
Try this formula for cell C1:
= IF(A1=B1,IF(A2=B2,"YES","NO"), "NO")
2007-05-31 05:52:12 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Since the first statement is "If a1=b1", then shouldn't the results of "a1<>b1" be false?
I am confused?
2007-05-31 12:53:25 · answer #2 · answered by dewcoons 7 · 0⤊ 0⤋
try this:
=IF(AND(A1=B1, A2=B2),"Yes", "No")
I just came up with it, tested it, and it worked for me.
hope this helps.
2007-05-31 13:14:50 · answer #3 · answered by the_infielder44 2 · 0⤊ 0⤋
try specifying numbers instead of cell addresses
2007-05-31 13:07:07 · answer #4 · answered by aks 3 · 0⤊ 0⤋
=IF(AND(A1=B1,A2=B2),"yes","no")
2007-05-31 12:51:06 · answer #5 · answered by Rachel 6 · 0⤊ 0⤋