Quick Links ▼

Bookmark page

Printable version

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

IF function

Resolved · Low Priority · Version 2007

Reply Wed 16 Nov 2011, 19:59Delegate Sujal said...

Sujal has attended:
Excel Intermediate course

IF function

Does the IF statement always have to following the sequence; Question, True, False ?

For upcoming training course dates see: Pricing & availability

Reply Thu 17 Nov 2011, 16:55Trainer Paul said...

RE: IF function

Yes

Reply Thu 17 Nov 2011, 16:57Trainer Paul said...

RE: IF function

Saying that, it can get a bit confusing because your true or false can be more than true or false, ie, you might nest another function as the true or false. If you have a more specific example you would like me to look at let me know.

Thanks
Paul

Wed 23 Nov 2011: Automatically marked as resolved.

Excel articles

· A Picture Is Worth A Thousand Words (Or Numbers)
· How To Create A Macro In Excel 2010
· Discover The Top Ten Changes In Excel 2010
· How To Add Extra Data Ranges To An Excel Chart
· Using The Drawing Toolbar In Excel

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

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips