advanced excel training

advanced excel training - IF function

Resolved · Low Priority · Version Standard

IF function

Amanda has attended:
No courses

by - delegate Amanda [1 post] (2007 Mar 29 Thu, 15:32) Reply

Why would I use an IF function?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: IF function

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 30 Fri, 09:48) Reply

Hi Amanda,

Thank you for your question, you can use functions like the IF function to perform calculations based upon conditions. You can use the IF function to return one of two values based on whether a condition is true.

For example, IF(A1+B1>500, "Met target", "Under target")
so in this case depending on whether A1 + B1 is bigger than 500 will decide whether the return value is Met target or Under target.

Hope this helps

Tracy