[Year 12 IPM] Unit 4 Outcome 1

[Paul Drew]

Here's a tutorial I developed for vlookup. Nested if's are good but are
limited to seven (I think). There is also an hlookup function.

Thanks to Brad Owens for the third page of the tutorial.

Regards

Paul Drew
Ashwood Secondary College


-----Original Message-----
From: ipm-bounces at edulists.com.au [mailto:ipm-bounces at edulists.com.au] On
Behalf Of Emma Coughlan
Sent: Friday, 20 May 2005 7:57 AM
To: ipm at edulists.com.au
Subject: [Year 12 IPM] Unit 4 Outcome 1

Morning everyone,

Just wondering if anyone could help me. I am starting
unit 4 outcome 1 and we are using Excel. Does anyone
have any excel exercises? particularly nested If
statements.

If anyone has anything it would be greatly
appreciated.

Thank you :)

Kind Regards,

Emma Coughlan
St Helena Secondary College
Eltham

Enjoy your day as you never know whats around the corrner


	
	
		
___________________________________________________________ 
Yahoo! Messenger - want a free and easy way to contact your friends online?
http://uk.messenger.yahoo.com
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IPM Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority
and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
Association Inc


Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pdvlookup.xls
Type: application/vnd.ms-excel
Size: 388096 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20050520/5e396286/pdvlookup-0001.xls