The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested IF function

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Nested IF function

Resolved · Medium Priority · Version 2007

ReplyTue 15 Sep 2009, 16:28Delegate William said...

Nested IF function

Don't know quite how they work and also about further logical function

For upcoming training course dates see: Pricing & availability

ReplyWed 16 Sep 2009, 16:19Trainer Simon said...

RE: nested IF function

Hi William,

Thank you for your question.

A Nested If is used if you want to test a cell against multiple conditions.

An IF function only allows you to test a cell using one condition.

Here is an example:

=if(c5>100,50,if(c5>30,20,10))

I hope this answers your question.

Regards

Simon

Wed 23 Sep 2009: Automatically marked as resolved.

Excel articles

· Training Budgets In A Bad Economy
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series
· VBA Excel 2007
· Radio Buttons And Check Boxes In Excel
· Microsoft Excel Training: Not Just for Newbies Anymore

Please browse our web site to find out more about
2002 excel microsoft training and other Microsoft training courses.

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips

How do you merge spreedsheets that have not got identical data?

» Forum post: Merge spreedsheet

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions