+ Reply to Thread
Results 1 to 2 of 2

I would like a toggle button to toggle a formula in a range of cells

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    I would like a toggle button to toggle a formula in a range of cells

    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.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: I would like a toggle button to toggle a formula in a range of cells

    You can get the Universe number with:
    Please Login or Register  to view this content.
    But I don't understand what your ID number is counting.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Toggle Button
    By SZBELL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2013, 10:33 AM
  2. Toggle Code to format-unformat range of cells
    By Zimbo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2008, 03:01 AM
  3. Toggle button
    By keithl816 in forum Excel General
    Replies: 2
    Last Post: 11-21-2005, 05:16 PM
  4. How do I toggle a button across a range of columns
    By sodaboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2005, 09:05 PM
  5. Toggle Button
    By Dave_2k5 in forum Excel General
    Replies: 2
    Last Post: 09-01-2005, 07:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1