Hello -
What's the use case behind using the above formulas? Is it for working out HEX<>RGB color combinations?!
Sean
Hi Sean,
No, it's for converting between hexadecimal to decimal numbers.
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hey Andrée,
Thanks for the reponse - I understand that it's a conversion formula. What I'm trying to understand is what is the use case for using the formula?!
When I do a search on the forums here for "Hexadecimal" - I see one post from Craig related to color mapping is this why the formula was developed?
Cheers, Sean
Happy to help!
You're correct! It's also used for colors. (every day you learn something new)
Another example is programming. It's used to make the code more efficient.
Here's an excellent explanation:
3) Decimal number system
Decimal number system has only ten (10) digits from 0 to 9. Every number (value) represents with 0,1,2,3,4,5,6, 7,8 and 9 in this number system. The base of decimal number system is 10, because it has only 10 digits.
Applications:
We use decimals every day, while dealing with money, weight, length etc. Decimal numbers are used in situations where more precision is required, than the whole numbers can provide. For example, when we calculate our weight on the weighing machine, we do not always find the weight equal to a whole number on the scale. In order to know our exact weight we must understand what the decimal value on the scale means. This section deals with the concept of decimals in three important fields of our daily life.
4) Hexadecimal number system
A Hexadecimal number system has sixteen (16) alphanumeric values from 0 to 9 and A to F. Every number (value) represents with 0,1,2,3,4,5,6, 7,8,9,A,B,C,D,E and F in this number system. The base of hexadecimal number system is 16, because it has 16 alphanumeric values. Here A is 10, B is 11, C is 12, D is 13, E is 14 and F is 15.
A computer understands information composed of only Zeros and Ones. Therefore, when we type some letters or words, data is processed by the computer in the form of 0s and 1s. A computer can understand positional number system where there are only a few symbols called digits and these symbols represent different values depending on the position they occupy in the number. Computer is usually designed to process hexadecimal number.
For example, the images you see on your computer screen have been encoded with a binary line for each pixel. If a screen is using a 16-bit code, then each pixel has been told what color to display based on which bits are 0s and which bits are 1s. As a result, 2^16 represents 65,536 different colors! We also find the binary number system in a branch of mathematics known as Boolean algebra. This field of mathematics is concerned with logic and truth values. Here, statements that are either true or false are then assigned a 0 or 1.
Hexadecimal numbering system is often used by programmers to simplify the binary numbering system. Since 16 is equivalent to 24, there is a linear relationship between the numbers 2 and 16.
This means that one hexadecimal digit is equivalent to four binary digits. Computers use binary numbering system while humans use hexadecimal numbering system to shorten binary and make it easier to understand.
Hexadecimals are used in the following:
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
