If anyone have done P31 please notify us!
I have a question so please help!
In excel, is it essetial to write the same formula they write in the mark scheme?
For example if I used a neted IF function, I tend to do 3 loops of IF and I still get the answer right but in the mark scheme they only do 2... Here's a practical example:
My formula: =10000+IF(E2<=500,H2*0.05,IF(E2<4000,H2*0.075,IF(E2>=4000,H2*0.1)))
Mark scheme: =10000+(IF(E2<=500,H2*0.05,IF(E2<4000,H2*0.075,H2*0.1)))
(November 2012 P3^)
I still got all the records right and I've done this with other years in past papers and all are right! Help! Maybe? Thank you in advance! ^_^!
I have a question so please help!
In excel, is it essetial to write the same formula they write in the mark scheme?
For example if I used a neted IF function, I tend to do 3 loops of IF and I still get the answer right but in the mark scheme they only do 2... Here's a practical example:
My formula: =10000+IF(E2<=500,H2*0.05,IF(E2<4000,H2*0.075,IF(E2>=4000,H2*0.1)))
Mark scheme: =10000+(IF(E2<=500,H2*0.05,IF(E2<4000,H2*0.075,H2*0.1)))
(November 2012 P3^)
I still got all the records right and I've done this with other years in past papers and all are right! Help! Maybe? Thank you in advance! ^_^!