excel in courses - What are the basics for formulas

Resolved · Low Priority · Version Standard

What are the basics for formulas

Cathy has attended:
Excel Intermediate course

by - delegate Cathy [1 post] (2008 Jan 9 Wed, 14:04) Reply

I have not covered the basics is there any advice you can give me

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
2002/XP	2008 Dec 16 Tue	Tooting	0	FULL
Full Schedule: See all 108 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: What are the basics for formulas

by - delegate Paul gold contributer [121 posts] (2008 Jan 9 Wed, 14:46) Reply

click the fx to the left of the formula bar near the top of your workbook for a list of available formulae and play around!!

most commonly used formula I reckon is the if statement.

in cell B1, type the following:

=if(A1>10,"big number","small number")

this will return "big number" or "small number" based on the value in cell A1. if it's a number less than or equal to 10, it will return "small number" in cell B1, if it's a number larger than 10, it will return "big number"