I hope someone can help me.
I have to put in some pupil results on a spreadsheet, reading 3A, 3B, 3C or 4A etc.
I need a formula so that a graph or sorting sees the A as .8 the B as .5 and the C as .2.
I have been going round in circles all morning and can't make a formula work!
I would be so happy if someone could help me with this please.
Thanks in advance
Try this...
=IF(RIGHT(A1,1)="A",LEFT(A1)+0.8,IF(RIGHT(A1,1)="B",LEFT(A1)+0.5,IF(RIGHT(A1,1)="C",LEFT(A1)+0.2)))
Martin
That doesn't work sorry, thanks for tryingOriginally Posted by mrice
Try this...
=IF(RIGHT(A1,1)="A",LEFT(A1)+0.8,IF(RIGHT(A1,1)="B",LEFT(A1)+0.5,IF(RIGHT(A1,1)="C",LEFT(A1)+0.2)))
With
A1 containing 2-chars....a digit and a letter...eg 4B.
This formula replaces:
A with .8
B with .5
C with .2
and coverts the A1 text to the respective numeric value
In the above example, 4B is converted to 4.5B1: =LEFT(A1,1)+LOOKUP(RIGHT(A1,1),{"A";"B";"C"},{".8";".5";".2"})
Is that something you can work with?
Works for me -please see the attachment.
That does work, I should be able to work with that. Could I put in a command for row above rather than left?
Many thanks
If you're referring to the formula I posted....
With A1 containing the digit-letter text
The same formula in A2 still works:
Does that help?A2: =LEFT(A1,1)+LOOKUP(RIGHT(A1,1),{"A";"B";"C"},{".8";".5";".2"})
Thats fab all sorted.
Thanks a million
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Shazzney 
Register To Reply
Bookmarks