General Chat Thread, Excel mental block.... Help me please! in General; I am trying to convert a column of numbers to national curriculum levels... So 4 = 4, 4.33 = 4a, ...
22nd October 2013, 10:39 PM #1
Excel mental block.... Help me please!
I am trying to convert a column of numbers to national curriculum levels... So 4 = 4, 4.33 = 4a, 4.66 = 4b etc....
Can anyone help? Feeling a bit thick here at the moment!
22nd October 2013, 10:41 PM #2
vlookup using a small table?
22nd October 2013, 11:13 PM #3
This works, but you may need to adjust the IFs to match your data...
By Robman in forum Educational Software
Last Post: 5th May 2013, 09:20 PM
By laserblazer in forum General Chat
Last Post: 15th October 2012, 12:30 PM
By Admiral208 in forum Windows Vista
Last Post: 15th September 2008, 11:56 AM
By RabbieBurns in forum Windows
Last Post: 2nd July 2008, 01:51 PM
By callumtuckey in forum General Chat
Last Post: 14th February 2007, 09:23 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)