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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » if statements?

if statements?

ResolvedVersion 2007

Tue 20 Dec 2011, 16:27 Delegate Colm said...

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

if statements?

How does one perform a logical test of if statements?

Thu 22 Dec 2011, 09:44 Trainer Anthony said...

RE: if statements?

Hi Colm, thanks for your query. You'll need to use nested IF statements to achieve a series of logical tests. There's a useful walkthrough here:

http://www.bettersolutions.com/excel/EDH113/LI749589511.htm

Hope this helps,

Anthony

Thu 29 Dec 2011: Automatically marked as resolved.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

if statements?

if statements?

RE: if statements?

Excel articles

Excel tip:

Change the Value of a Constant