IF fuction,

Resolved · Low Priority · Version 2003

Wed 30 Jul 2008, 16:58 Delegate shipa said...

shipa has attended:
Excel Intermediate course

IF fuction,

what this is?

Fri 1 Aug 2008, 11:49 Trainer Carlos said...

RE: IF fuction,

Hi Shipa

The IF function in Excel allows you to test to see whether a certain condition is true or false.

If the condition is True, the function will do one thing, if the condition is False, the function will do something else. For example:

You have a value in Cell B3 - The Total Sales by a Salesperson

If the Salesperson sold more than

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

IF fuction,

IF fuction,

RE: IF fuction,

Excel articles

Excel tip:

Change the Value of a Constant

Training Programs
Professional & Management Development