[Year 12 IT Apps] Sample questions - again

[Mark Kelly]

Has anyone had a close look at 10a?

=IF($G$2>3900,3900*VLOOKUP(3900,$I$6:$J$8,2),$G$2*VLOOKUP($G$2,$I$6:$J$8,2,TRUE))

Does anyone reckon there's an error here?  I think the ">" should be "<" 
otherwise it makes no sense!

Must think about it when time permits - some time in term 3 perha[s  :-(

Mark


-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 95789253
kel AT mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au
IT Lecture notes: http://vceit.com
Moderator: IT Applications Mailing List

There are 10 kinds of people in the world: those who understand binary
and those who don't.