microsoft excel xp training

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Certified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

microsoft excel xp training - If statements

If statements

Claire has attended:
Excel Advanced course

by - delegate Claire [1 post] (2007 Mar 14 Wed, 09:41) Reply

How do I use grouped if statements?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: if statements

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 14 Wed, 11:32) Reply

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

microsoft excel xp training - If statements

Related articles

Excel tip:

Pivot table grouping