[Year 12 IPM] excel merge

[John McIntyre]

Hi Damien
The below will answer your query and also nests extra comment options for you.

=IF(B2>=12,B2&" and has worked well",IF(B2>=10,B2&" and has worked okay",B2&" needs to improve"))

Regards

John McIntyre
Good Shepherd College
Hamilton
it at gsc.vic.edu.au
  ----- Original Message ----- 
  From: Damien A-B 
  To: 'Year 12 Information Technology Processing and Management Teachers'Mailing List' 
  Sent: Tuesday, May 31, 2005 10:23 AM
  Subject: RE: [Year 12 IPM] excel merge


  Hi Andrew

  Try =CONCATENATE(B2," has worked Well")

  Cheers

  Damien A-B

  IT Dept

  Keilor Downs College


------------------------------------------------------------------------------

  From: ipm-bounces at edulists.com.au [mailto:ipm-bounces at edulists.com.au] On Behalf Of Andrew Grimshaw
  Sent: Tuesday, 31 May 2005 10:11 AM
  To: Year 12 Information Technology Processing and Management Teachers'MailingList
  Subject: [Year 12 IPM] excel merge

   

  hi 

   

  i hope this is not too silly a question

   

  im trying to get excel to do something fairly simple but i keep coming unstuck

   

  i want it to insert a name from a colum into a line of text

   

  a simple cell reference will insert the name but as soon as u add other text u get an error message

   

   (see attached screen dump)

   

   

  any ideas out there?

   

  -andrew grimshaw

  Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training._______________________________________________ 
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
  IPM Mailing List kindly supported by 
  http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and 
  http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc


  Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training._______________________________________________ 
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
  IPM Mailing List kindly supported by 
  http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and 
  http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/ipm/attachments/20050531/a7286ea9/attachment.html