Sue has attended:
Excel Introduction course
Formulas
I would like to create a formula that check 3 separate cells and confirm "yes" they agree, is this possible? This is actually a spreadsheet that I am working on today, appreciate your help. Kind regards Sue
RE: Formulas
Hi Sue, Thanks for the post, in answer to your question it sounds like an 'AND' function is required;
The And function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.
The syntax for the And function is:
And( condition1, condition2, ... )
Condition is something that you want to test that can either be TRUE or FALSE. There can be up to 30 conditions.
These can be values or Cell References, so your formula could be
=AND(A1,B1,B3) and if the three cells all have the same value you will have the return TRUE, if any of them are different then the result will be FALSE, I hope that helps, good luck, Pete.
