+ Reply to Thread
Results 1 to 2 of 2

Typing an array into a formula rather than referring to an array of cells

  1. #1
    Registered User
    Join Date
    09-22-2009
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2010 (Work) O365Home (Home)
    Posts
    94

    Typing an array into a formula rather than referring to an array of cells

    Hi,

    I am trying to type an array into a formula. The values of the array equate to a simple rotation matrix which i intend to perform matrix multiplication with but i am getting stuck when trying to confirm the formula i type;

    Please Login or Register  to view this content.
    when i try to confirm the formula by pressing the return key excel gives me a generic formula error message and highlights in black the first occurance of the trigonometric function - the first being the cosine function...

    If i delete the cosine function and replace it with the number 1 and then try and confirm excel errors again highlighting the first trigonometric function, this time the sine function.

    Does excel not like resolving calculations within an array?

    Thanks
    Alex

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Typing an array into a formula rather than referring to an array of cells

    Excel does not recognize formula (only text and numbers) within the array {}, hence the error.

    Upload a sample of what you are trying to achieve with expected results, might be easier conceiving a solution
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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. Replace hard coded array in formula with link to input array
    By David Brown in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-08-2011, 07:45 AM
  2. Referring to an array column or row of LinEst function
    By HammerTime in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2010, 01:11 AM
  3. Converting 3x10 array to a 1X30 array to run a Match formula
    By NBVC in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-08-2009, 07:45 AM
  4. [SOLVED] Referring to multiple elements of an array (VB)
    By Phil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2005, 12:50 AM
  5. [SOLVED] Tricky array formula issue - Using array formula on one cell, then autofilling down a range
    By aspenbordr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2005, 11: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