+ Reply to Thread
Results 1 to 3 of 3

Curly brackets from google sheets to Excel HELP!

  1. #1
    Registered User
    Join Date
    03-15-2022
    Location
    London, England
    MS-Off Ver
    Excel
    Posts
    1

    Curly brackets from google sheets to Excel HELP!

    Hi all.

    I've recently taken the step from google sheets to Excel. I've tried to download my google sheet into a Excel file and been fairly successful transfering it over - except one key formula that I'm using. The formula contains curly brackets and I believe that's the issue. My question is: Could anyone here help me get the following formula to work in Excel?

    The formula:

    =if(iserror(irr({(L$13*-1),M$18,N$18,(O$13+O$18)},0.1)),"",irr({(L$13*-1),M$18,N$18,(O$13+O$18)},0.1))

    Thanks for your time.

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: Curly brackets from google sheets to Excel HELP!

    Hi,

    Curly brackets in Excel refer to an Array. Try pressing the Ctrl, Shift, and Enter keys together after typing the formula into your cell.

  3. #3
    Valued Forum Contributor
    Join Date
    01-07-2022
    Location
    Europe
    MS-Off Ver
    Office 365
    Posts
    473

    Re: Curly brackets from google sheets to Excel HELP!

    Do you mean the curly brackets in the middle of the formula?
    The control+shift+enter array adds curly brackets to the beginning and end of the formula, so might not be what you need here.

    Ideal if you can share a sample of the spreadsheet, together with your expected result from the formula.
    <<< If you have valued anyone's contributions in this thread, please click * to thank them for their efforts

+ 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. Curly brackets / arrays in if statement formulas
    By Mahisse in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2018, 09:16 AM
  2. [SOLVED] How to enter array formula with curly brackets into cell
    By Imbizile in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2017, 09:55 AM
  3. [SOLVED] SUM(COUNTIF.. with more than one pair of curly brackets ?
    By Gabor in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-30-2013, 03:46 PM
  4. what is the meaning of curly brackets in the functions { }
    By funtastic in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-04-2013, 04:23 PM
  5. What do curly brackets /braces {} do in VBA
    By Huugin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2012, 04:33 PM
  6. [SOLVED] Excluding Single Member from CUBEVALUE using Curly Brackets
    By tlafferty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2012, 05:58 PM
  7. [SOLVED] Curly Brackets in formula view
    By VBSK8R in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-04-2012, 09:32 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