if statement

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » If statement

If statement

resolvedResolved · Low Priority · Version 2007

Steve has attended:
Excel Intermediate course

If statement

where is it located ?

RE: if statement

Hello Steve

Thank you for your question and welcome to the forum.

You can launch the IF function by selecting a cell in your spreadsheet where you want the function to go; then either click the fx button to the left of the formula bar; or go to the Formulas ribbon and click the Insert Function button.

Then select Logical from the Categories box - IF should show in the list at the bottom of the Insert Function dialogue box.

Kind regards
Amanda

Thu 9 Apr 2009: Automatically marked as resolved.


 

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips


Server loaded in 0.08 secs.