+ Reply to Thread
Results 1 to 5 of 5

Adjusting formulas

  1. #1
    Registered User
    Join Date
    10-16-2017
    Location
    Charlotte
    MS-Off Ver
    2016
    Posts
    31

    Adjusting formulas

    I have attached an excel document. If I put in values from A1 to D1 such that SQRT(A1^2+B1^2+C1^2+D1^2)=1, and have A7=0 only some values, in which ABS(B7)+ABS(C7)+ABS(D7) does not equal 0, and only certain values for A1, B1, C1, and D1, will lead to D20=SQRT(2). Also if I reverse all the values of A1 through D1 or B7 through D7 it changes the absolute values for A19 through D19 instead of simply reversing all the values for A19 through D19. How can I adjust my formulas so that D20=SQRT(2) for any value of A1 through D1 in which SQRT(A1^2+B1^2+C1^2+D1^2)=1, and for any combination of B7 through D7, and in which ABS(B7)+ABS(C7)+ABS(D7) is not equal to 0, and whenever A7=0, without changing the formula in D20? Also how do I adjust the formulas so that reversing all the values for A1 through D1 or B7 through D7 reverses the values of A19 through D19 instead of changing the absolute values of A19 through D19? Also any change to the formulas needs to keep E19=1 without changing the formula in E19. Also A8 through D8 need to keep their formulas.
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Adjusting formulas

    Can you provide a little background on what you're trying to do?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-16-2017
    Location
    Charlotte
    MS-Off Ver
    2016
    Posts
    31

    Re: Adjusting formulas

    A1 through D1 contain the coordinates of a point on a 4d hypersphere with a radius of 1, and centered at the origin. A8 through D8 also contain the coordinates for another point on the same 4d hypersphere, which is a random point with a position vector perpendicular to the position vector of point (1,0,0,0). What I am trying to do is to mathematically rotate the 4d hypersphere so that the point (1,0,0,0) moves to the same coordinates specified by A8 through D8. I'm trying to calculate the coordinates that the point specified by A8 through D8 will end up at when I rotate the 4d hypersphere like this in A19 through D19.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Adjusting formulas

    Dunno anything about four-space.

    In three-space, I'd form a quaternion rotation whose axis is along the cross product of {1,0,0} and the vector in A8:C8 (which is perpendicular to both), and whose angle is the arcsin of the magnitude of the cross product (which is the angle between those vectors).
    Last edited by shg; 06-02-2018 at 11:26 AM.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Adjusting formulas

    BTW,

    =A1/ABS(A1) * D9/ABS(D9) * B10 * COS(B6/ABS(B6) * B11 + B6) is the same as

    =SIGN(A1) * SIGN(D9) * B10*COS(SIGN(B6) * B11 + B6)

    ... except that it doesn't error when any of those values is zero.

+ 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] Pasting formulas and adjusting to new tab
    By bigjdawg43 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2018, 04:18 PM
  2. Consolidating data to a single page and adjusting formulas
    By sm370 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-13-2016, 06:37 PM
  3. Non-adjusting References in Formulas
    By jlyh11 in forum Excel General
    Replies: 6
    Last Post: 11-11-2015, 02:57 AM
  4. [SOLVED] prevent Excel from adjusting formulas when inserting new columns of raw data
    By fmxwannabe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2013, 03:13 AM
  5. Replies: 7
    Last Post: 08-19-2012, 03:40 PM
  6. deleting a worksheet and auto adjusting formulas
    By bobbak in forum Excel General
    Replies: 6
    Last Post: 09-11-2009, 11:23 AM
  7. automatically adjusting formulas on filtering
    By markwilest in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-15-2007, 09:59 AM

Tags for this Thread

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