Excell

The UK's most regular instructor-led training courses.
Training information: excel+course · Excel advanced · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Excell

Maciej has attended:
Excel Intermediate course

by - delegate Maciej [1 post] (2008 Apr 23 Wed, 17:05) Reply

Can I write VB codes to make conditional formulas?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 28 Thu	Southwark	0	FULL
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
Full Schedule: See all 139 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excell

by - trainer Alan silver contributer [59 posts] (2008 May 18 Sun, 17:46) Reply

Yes. Record a macro which builds the IF function into the cell. This will generate the code for you and you can then edit it in the VBA editor.

· A Beginners Guide To Formulas In Excel
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Benefits of learning about Excel charts

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

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips