Hi
Im using microsoft excel for my a-level project.
my project is for a primary school teachers grading system.
However when i change the possible marks from 100 to anything above that the VLOOKUP formula will not work correctly and 1%, 3% 5% 7% ect will *** up with #N/A this is by changing the possible marks from 100 to 200.
The formula that i'm using is =VLOOKUP(H14,'Grades Table'!E5:F105,2,FALSE)
Is there anyway or anything that I will be able to do so no matter how many marks the tests are out of this error will not appear
Please see attachment and have a look and try for yourself.
Any ways to resolve this issue please comment!
Jack
if possible marks are 200 then you need to recalc your % table else 11% based on 100 changes to 5.5% which is not in your table hence the #n/a, so you'll have to include all 1/2% in your table. or round/up/down to nearest % .
just to confuse maters your cell format is percentage no decimal places so say 5.5 appears as 6 which is probably why you didnt spot it.
Last edited by martindwilson; 01-05-2012 at 07:32 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Do you know of a quick and easy way to round them up ?
Jack
CHEERS,
That has helped and now solved my problem
thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks