+ Post New Thread
Results 1 to 3 of 3
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, ...
  1. #1
    denon101's Avatar
    Join Date
    Jul 2008
    Location
    Stuck in the server room......
    Posts
    395
    Thank Post
    54
    Thanked 37 Times in 35 Posts
    Rep Power
    21

    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!

    Ta

  2. #2
    jamesreedersmith's Avatar
    Join Date
    Sep 2009
    Location
    Ruskington
    Posts
    1,158
    Thank Post
    78
    Thanked 253 Times in 227 Posts
    Rep Power
    77
    vlookup using a small table?

  3. #3

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168
    This works, but you may need to adjust the IFs to match your data...
    levels.xls

SHARE:
+ Post New Thread

Similar Threads

  1. Help me please
    By Robman in forum Educational Software
    Replies: 2
    Last Post: 5th May 2013, 08:20 PM
  2. Can someone with Google Chrome help me please?
    By laserblazer in forum General Chat
    Replies: 3
    Last Post: 15th October 2012, 11:30 AM
  3. SOMEONE HELP ME!!! PLEASE!!!
    By Admiral208 in forum Windows Vista
    Replies: 4
    Last Post: 15th September 2008, 10:56 AM
  4. excel lookup problem, can someone help me please?
    By RabbieBurns in forum Windows
    Replies: 3
    Last Post: 2nd July 2008, 12:51 PM
  5. help me please !!!!
    By callumtuckey in forum General Chat
    Replies: 19
    Last Post: 14th February 2007, 08:23 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •