How can I get Microsoft Excel to recognise hexadecimal numbers?

Question

I am looking to set up a 'Grade' book, for which I use the letters A, B, C, and D to note the condition of a particular item. However I cannot seem to find a formatting option to have the letters recognised as a value. I think using hexadecimal numbers would be a solution but, have no idea how to make it work.

I am looking to set up a spreadsheet where I can log the condition of fruits and vegetables. The condition of the produce is categorised into either A, B, C or D depending on how the fruit or vegetable meets the criteria set out in a specification.

As you would expect, fruit and vegetables can vary in quaIity. I would therefore like to be able to find out the average condition of a particular fruit or vegetable. However because A, B, C or D is not a numeric value I cannot obtain an average.

For example if my set of data for onions was A,B,B,A,C,D,C,B,B,B,B,A, - I am looking to get the spreadsheet to tell me that my onions are averaging a grade B (in this example).

Answer 1

Ok, do you know how to do match index?

In a sheet set out your grading so you have somthing like this:

A | 1
B | 2
C | 3
D | 4

etc.

use this function:

=INDEX(CELLS_WITH_NUM,MATCH(GRADE,LIST_OF_GRADES,0),0)

You'll really need to read up on the Index() and Match() functions in Excel for this to make any sense!

Answer 2

This Site Might Help You.

RE:
How can I get Microsoft Excel to recognise hexadecimal numbers?
I am looking to set up a 'Grade' book, for which I use the letters A, B, C, and D to note the condition of a particular item. However I cannot seem to find a formatting option to have the letters recognised as a value. I think using hexadecimal numbers would be a solution but, have no...

Answer 3

1

Answer 4

Excel Hexadecimal

Answer 5

here it is---hope it helps you
if you need more info--goto Excel Help and type hexadecimal

Convert a decimal number to hexadecimal
To do this task, use the DEC2HEX function.

A B
1 Formula Description (Result)
2 =DEC2HEX Converts decimal 100 to hexadecimal
(100, 4) with 4 characters (0064)

3 =DEC2HEX Converts decimal -54 to hexadecimal
(-54) (FFFFFFFFCA)

Answer 6

Excel doesn't support hexadecimal numbers. However, it does have HEX2DEC and DEC2HEX functions that you can use. You need to have the Analysis tool pack loaded to use them.

Answer 7

Do you like gardening? Do you like to be innovative? Do you are short of income to pay for it professionally? Then make your own landscaping with the support of this web site https://tr.im/XFJJL Ideas 4 Landscaping , the perfect guide for persons like you.
Ideas 4 Landscaping is a layout assortment produced to support home owners come up with new concepts to style their residences. The plan is undoubtedly the most comprehensive land resource on the net , with a database of more than 7000 color pictures , movies tutorials , themes , as properly as the newest trends in landscaping. With this large assortment of images , themes , straightforward to stick to guides , there is no want to employ designers or subscribe to annual landscaping magazines.
This manual , Ideas 4 Landscaping has every little thing you need to have to successfully landscape your dream garden.

Answer 8

Tv set is produced to the cheapest common denominator - i.e., the common IQ of the general public, whereas a book is written to the highest common denominator

Answer 9

fruit grows on woods or vines and fresh vegetables grow in the floor.

Answer 10

The letters A, B, C and D already have a value. You can already do conditional processing using the if() function.

So give us a clue. What do you want to do exactly.