+ Reply to Thread
Results 1 to 5 of 5

Does anyone know what this function is!!!! HELP

  1. #1
    Registered User
    Join Date
    11-06-2015
    Location
    San Diego
    MS-Off Ver
    2013
    Posts
    82

    Does anyone know what this function is!!!! HELP

    Hi guys,
    Does anyone know what this equation is? {=SUM(IF($C$12:$L$12>0,($C$12:$L$12/$C$13:$L$13)*C44:L44*$C$13:$L$13))/$M$13}
    so the {} before the equal sign is in the equation and it still computes its so weird. Also once I click on the equation to see the highlighted cells it refers to the {} go away and now it shows up as VALUE!. like wtf is this? When I put the {} back it doesnt work like I have to close the workbook and reopen to see the number it computes. can someone help me here. is like maybe explain what its doing and how I can fix it.
    Thank you,
    Your Friend!!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Does anyone know what this function is!!!! HELP

    The squiggly brackets around the formula mean it's an array formula.

    Array formulas are entered differently than a regular formula. After you type in a regular formula you hit the ENTER key. With an array formula you must use a combination of keys. Those keys are the CTRL key, the SHIFT key and the ENTER key. That is, hold down both the CTRL key and the SHIFT key then hit the ENTER key.

    When done properly Excel will enclose the formula in squiggly brackets { }. You can't just type these brackets in, you must use the key combo to produce them. Also, anytime you edit an array formula it must be re-entered as an array using the key combo.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,862

    Re: Does anyone know what this function is!!!! HELP

    The { } indicates it is an Array formula : the formula is entered into the cell as

    =SUM(IF($C$12:$L$12>0,($C$12:$L$12/$C$13:$L$13)*C44:L44*$C$13:$L$13))/$M$13 (no { } brackets)

    THEN

    HOLD down CTRL+SHIFT then hit ENTER

    (CtrL+Shift+Enter)

    If this is done correctly, the {.........} will appear round the formula

    To see how it works highlight cell then "Evaluate Formulas" on the "Formula" ribbon,

    Click "Evaluate" and it will step through the calculation.

  4. #4
    Registered User
    Join Date
    11-06-2015
    Location
    San Diego
    MS-Off Ver
    2013
    Posts
    82

    Re: Does anyone know what this function is!!!! HELP

    Thank you guys,
    Problem solved. I appreciate the help this forum is awesome!,
    :-)

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Does anyone know what this function is!!!! HELP

    You're welcome. We appreciate the feedback!

+ 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. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  2. VBA code for custom function that returns detail results of array function
    By onechipshot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2015, 06:30 PM
  3. Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  4. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  5. Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  6. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  7. Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 PM

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