I would like a toggle button to change the display format of a range of cells (or apply a formula?)
The information in its bare form is numerical: 1, 2, 3, ...........1024, 1025, 1026.
The number system is based on groupings of 512. 512 consecutive numbers are referred to as a Universe. I am looking to create a document with 150 Universes, or 150 different instances of 1 through 512.
For example,
Form A = Form B
1 = 1.1 (Value = Universe Number . ID number) Where Value is any number between 1 and 76800, Universe number is anywhere between 1 and 150, and ID number is between 1 & 512.
2 = 1.2
3 = 1.2
100 = 1.100
500 = 1.500
513 = 2.1
514 = 2.2
1024 = 2.512
1025 = 3.1
And so on
=IF(A1<512,A1,IF(AND(A1>512,A1<=1024),A1-512,IF(AND(A1>1024,A1<=1536),A1-1024,IF(AND(A1>1536,A1<=2048),A1-1536
A1 = 1025
Toggle would display A1 (via the formula) as 1. (in universe 3. Ultimate goal would be for it to display as 3.1 - (Universe 3, ID 1)
Does this make sense? Please give feedback, and I will do my best to explain.
Bookmarks