Cells with text calculating formulas

[halgraham]

Can anyone help please?

See my attached spreadsheet.

In my 'baseline level' column the students will be given a level when they come into school which will be a 3a,3b, 3c and so on and each student should make 2 sub levels of progress each year, so for example, on my excel sheet student 1 has a baseline assessment of a 3a that students 'end of year target level' is then a 4bTracking.xls and their 'end of KS3 target level' is a 5a. is there a way/formula that when I put the students 'baseline level' in it automatically calculates both their 'End of year level' and their 'End of KS3 target level'.

I know your probably thinking its just as easy to manually input the values but I am dealing with in excess of 800 pupils so therefore this will save hours.

Thanks in advance for your help

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-form...-and-text.html

Thread Closed.