microsoft excel courses in - F Function

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

Resolved · Low Priority · Version Standard

F Function

Daniel has attended:
Excel Introduction course

by - delegate Daniel [1 post] (2007 Feb 28 Wed, 10:05) Reply

What is the F function

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: F Function

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 28 Wed, 15:23) Reply

The IF function is based on a true or false situation, for example

=IF(A1>100, "Above target", "Under target")

dependent on whether the first condition (A1>100) is true the function will reveal the word Above target, and if is not true it will reveal the word Under target.

You have to put speech marks in if you want to reveal text, however if you want to put numbers you can leave the speech marks out.

For example

=IF(A1<1000, 20, 10)

So this would be interpreted as if the contents of A1 were less than 1000 it will give the number 20(i.e if the condition A1<1000 were true), if not it will give the answer 10.

Hope that helps, if there is anything specific you need to know get back to me

Thanks

Tracy

PS) If you meant something else rather than the IF function let me know