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 Tue 13 May 2008, 16:55Delegate Tristan said...

Tristan has attended:
Excel Intermediate course
Excel Advanced course

IF Function

How would I pick out individual characters within a cell and link it to an IF function?

For upcoming training course dates see: Pricing & availability

Reply Sun 18 May 2008, 18:19Trainer Alan said...

RE: IF Function

You could use a LEFT/RIGHT/MID function to pick out individual characters. You would have to nest this function into the IF function.

Excel articles

· Sparklines And Splicers: The New Face Of Excel 2010
· Flexible uses for Excel at Home
· Going Against The Grain With Multiple Radio Buttons In Excel
· Copy And Paste In Excel
· Getting To Grips With Gantt In Excel

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

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips