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

microsoft+excel+training+course - formulas

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training+course - Formulas

microsoft+excel+training+course - Formulas

ResolvedVersion Standard

Sarah has attended:
Excel Advanced course

Formulas

Please explain the False command.

RE: Formulas

Hi Sarah, Thank you for the post, in answer to your question, the FALSE command does just that, if a statement is correct Excel will return TRUE, if not it will Return FALSE, for example if you enter 100 in cell A1, and 50 in cell B1, if in C1 you enter the formula =A1>B1 Excel will enter TRUE, however if you enter =A1<B1 Excel will enter FALSE, I hope that helps, regards Pete.

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.44 secs.