[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