IGCSE/GCSE/O & A Level/IB/University Student Forum

Qualification => Subject Doubts => GCE AS & A2 Level => Miscellaneous => Topic started by: abdjed1 on March 19, 2011, 05:03:14 pm

Title: AICT Nov 2010 Problem
Post by: abdjed1 on March 19, 2011, 05:03:14 pm

How do I do task 21:
"Insert a formula in cell K2 which uses the file NXMONTH.CSV to look up the season
from the Start date and adds this to the date.
For example: 01/01/2010 will be displayed as 01 January 2010 (Winter)"

I know the answer(checked the mark scheme) but can someone explain it to me??

Title: Re: AICT Nov 2010 Problem
Post by: narnia on March 23, 2011, 06:18:02 am

check the attached file...
u have to use the concatenate function here alongwith text and lookup functions.