formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · Urgent Priority · Version 2003

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.


RE: Formulas

Thank you for the quick response Pete, that is excellent...it works :-)


 

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Server loaded in 0.08 secs.