Edexcel GCE Applied ICT Unit 3- June 2011 Exam

Nopes I havn't .. Its on 25th May

mines on 23rd and do u know hw to do activity 5

mines on 23rd and do u know hw to do activity 5

Will someone be able to email me how to do activity 4 and 5 please, teacher doesn't have a clue

hi iv gt my exam next friday
i really need help with activity 2 and 4
cud someone plz send me thier
also this is the formular i got
=if(and(value!$b7="yes",b$21="yes&quot,b7,0)
it does wrk but it is differnt from saidas
ps dnt forget to look at the rating when u open the shop as if above 1 it is good as falmouth is rated as 1.
hope it help
pzl cud some1 help me
:~

sorry to bother u so much but could u help me with the advertising formulas

so u type them in ur or is their a easier way of doing that

thankz

Hey .. basically my formula for advertising is abit longer with an AND ...? thats not necessary! you can just do either :

> =IF(AND(Values!$B7="Yes",Values!B$21="Yes"),Advertising!B7,0)

> =IF(Values!$B7="Yes",Values!B$21="Yes"),Advertising!B7,0)

& a few other simple ones work but im not sure how to do them!

email me

yeah,.. whats ur email.. il send em 2 ya..

did u get taught this in ur lessons coz i hav no clue wat IF and is

thank you for that but can u send me ur task 2 and 4 and plz

Yep got taught in lesson.. Basically IF( values 1 and 2 are 'yes' then the value of advertising is added otherwise 0)...
AND is only put there because your adding two values, but not compulsory!




Yeah.. il help you just inbox me your email address...

hav u done the exam already if not how do u know so much about it thanks

i just went through it.. dont know to much lol but if you went through a few past papers u'll see the answers are quite continuous and re-occurring .. also have good teachers and sharing answers from tsr..

ur good at activity 3 and i havent even got taught the IF formulas on monady im dead in the exam

ur good at activity 3 and i havent even got taught the IF formulas on monady im dead in the exam