Hi Guys
I am a teacher and am trying to get excel to substituite childrens grades at year 2 to what they should get at year 6, for example, a child getting a 2b at year 2 should get a 4b at year 6.
How can i write a formula that will change childrens levels in one cell to predicted levels in another cell. (conversion rules below)
w = 2b
1c = 3c
1b = 3b
1a = 3a
2c = 4c
2b = 4b
2a = 4a
3c = 5c
3b = 5b
3a = 5a
Much appreciated help
Andy
Bookmarks