[Year 12 IT Apps] Sample questions - again

Mark Kelly kel at mckinnonsc.vic.edu.au
Thu May 31 16:49:35 EST 2007


Had a longer look... and it's an odd thing indeed.

If my calculations are correct...

For one thing, the IF's true expression (3900*VLOOKUP(3900,$I$6:$J$8,2)
is an invariant calculation - it gives 39.00!

So if the usage is any value over 3900, charge a flat rate of $39.00,
and if it's a small usage, charge on a sliding scale that also uses an
invariant row in the lookup table - the rate will always be .01!

So the formula actually resolves to:
  =IF( $G$2>3900 , 39.00 , $G$2*.01 )

I wish MY gas company charged like that  :-)

One hopes such a question is not a true sample of what to expect at the 
end of the year!

Mark Kelly wrote:
> 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.






More information about the itapps mailing list