[Year 12 IPM] Practice SAC question
Mark Kelly
kel at mckinnonsc.vic.edu.au
Sat Jul 15 19:06:43 EST 2006
A solution is attached...
The 2-dimensional lookup is achieved with a second lookup in a second
lookup table.
A bit tricky, but a valuable technique. Note: the BA,MD, PHd etc table
must be in ascending alphabetical order for it to vlookup correctly.
HTH
Mark K
Diane Peat wrote:
> Hello everyone
> As part of the practice tasks for SAC 4/1, I intend to give the students the
> attached spreadsheet of salaries. But I'm nowhere near as clever as I
> thought I was! Now I'm a bit stumped over the formula I would need to
> calculate salaries. Is there a wiz out there who could tell me the formula?
> I tried If/And but I still got confused. I know I know this but I've had a
> mental block after not teaching it for two years. And also, am I getting in
> too deep for them do you think?
>
> Many thanks.
> Diane Peat
> Firbank Grammar School
> BRIGHTON VIC 3186
>
> _______________________________________________
> 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
--
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000 << new number!
School Fax +613 9578 9253
Webmaster - http://www.mckinnonsc.vic.edu.au
IPM Lecture notes: http://vceit.com
Moderator: IPM Mailing List
1. We must pity one another, and be gentle.
2. Doctor - "We must all face reality sooner or later"
Dowd - "I wrestled with reality for 35 years, doctor, and I'm
happy to say I won out over it."
From 'Harvey', 1950.
3. I'm a gay, black, left-handed communist Jew. Got a problem with that?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Salaries-FIX.xls
Type: application/vnd.ms-excel
Size: 15872 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20060715/be1dfeca/Salaries-FIX-0001.xls
More information about the ipm
mailing list