Combining IF and AND formulas

**regularguy** · 09-14-2010, 03:57 PM

Hello,

I have three rows of data in a spreedsheet I am stuck on IF formulas. I have three rows of data. I need to combine IF statements that says:

IF b3=c3,true, false and IF c3=d3, true, false, and IF b3=d3, true, false. Basically, I need to be able to have the numbers in all three rows be the same, so if they are, then it's true. If there is a discrepancy in any of the three rows, false. For example, row B is 99, row C is 99, and row D is 90. Then I need the formula to tell me that the three rows do not match and is false. Can anyone help me please?

**quanimal** · 09-14-2010, 04:04 PM

Originally Posted by regularguy

Hello,

I have three rows of data in a spreedsheet I am stuck on IF formulas. I have three rows of data. I need to combine IF statements that says:

IF b3=c3,true, false and IF c3=d3, true, false, and IF b3=d3, true, false. Basically, I need to be able to have the numbers in all three rows be the same, so if they are, then it's true. If there is a discrepancy in any of the three rows, false. For example, row B is 99, row C is 99, and row D is 90. Then I need the formula to tell me that the three rows do not match and is false. Can anyone help me please?

=IF(AND(A1=B1, B1=C1), "true", "false")