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 » If functions

	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:

If functions

Resolved · Low Priority · Version 2007

ReplyTue 15 Sep 2009, 16:29Delegate Bina said...

If functions

What is a nested if function

For upcoming training course dates see: Pricing & availability

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

RE: If functions

Hi Bina,

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

· Excel Charts As Easy As Pie
· Trust Excel To Protect Your Data
· How Many Different Ways Can You Sum In Excel 2007?
· Create Buttons To Navigate Between Worksheets
· Using Excel In Any Condition

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

Excel tip:

Bring up formatting dialog box

Ctrl+1

View all Excel hints and tips

A function key to be able to calculate only weekdays (and minus weekend dates).

How to make a vertical list and associating information into a horizantal row with info going downwards.

» Forum post: Date Formating

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