Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007 - AND/IF

Excel 2007 - AND/IF

ResolvedVersion Standard

Wed 12 Mar 2008, 15:27 Delegate Katie said...

Katie has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Excel 2007 - AND/IF

What does Logical Test mean?

Thu 20 Mar 2008, 20:17 Trainer Cress said...

RE: Excel 2007 - AND/IF

Logical_test is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Activating the formula bar with the keyboard in Excel 2010

The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell.

View all Excel hints and tips

Excel 2007 - AND/IF

Excel 2007 - AND/IF

RE: Excel 2007 - AND/IF

Excel articles

Excel tip:

Activating the formula bar with the keyboard in Excel 2010