microsoft excel xp training - if statements

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel xp training - If statements

microsoft excel xp training - If statements

resolvedResolved · Low Priority · Version Standard

Claire has attended:
Excel Advanced course

If statements

How do I use grouped if statements?

RE: if statements

Hi Claire,

Thank you for the question

The IF function is based on a true or false situation, for example

=IF(A1>100, "Above target", "Under target")

dependent on whether the first condition (A1>100) is true the function will reveal the word Above target, and if is not true it will reveal the word Under target.

You have to put speech marks in if you want to reveal text, however if you want to put numbers you can leave the speech marks out.

For example

=IF(A1<1000, 20, 10)

So this would be interpreted as if the contents of A1 were less than 1000 it will give the number 20(i.e if the condition A1<1000 were true), if not it will give the answer 10.

How you deal with nested IF statements is similar.

for example =IF(A1<50, "Fail", IF(A1<60, "Pass", IF(A1<70, "Merit", IF(A1<80, "Distinction"))))

the key is to keep the bracket open till the end, also make sure your conditions are in order, so that if the first condition is not met it is logical to go on the next.

Hope that helps, if there is anything specific you need to know get back to me

Thanks

Tracy


 

Excel tip:

Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

View all Excel hints and tips


Server loaded in 0.09 secs.