If formula- I hope someone can help me

[Shazzney]

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

[mrice]

Try this...

Please Login or Register  to view this content.

[Shazzney]

Try this...

Please Login or Register  to view this content.

That doesn't work sorry, thanks for trying

[Ron Coderre]

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

Please Login or Register  to view this content.

In the above example, 4B is converted to 4.5

Is that something you can work with?

[mrice]

Works for me -please see the attachment.

[Shazzney]

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

[Ron Coderre]

If you're referring to the formula I posted....

With A1 containing the digit-letter text

The same formula in A2 still works:

Please Login or Register  to view this content.

Does that help?

[Shazzney]

Thats fab all sorted.

Thanks a million