Results 1 to 4 of 4

Trying to SPILL a large multi-step formula

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2022
    Location
    Oakville, Ontario
    MS-Off Ver
    365
    Posts
    38

    Trying to SPILL a large multi-step formula

    Trying to SPILL a large multi-step formula with each SPILLED cell representing a step in the formula

    =((([@A1]/4)^1.25+(B1)^1.3+(C1)+(D1*10)^1.125+(E1+1)*(F1+G1/2+H1*2+1)/80+(I1*30)+(J1/2)^1.125+((K1+1)+(ABS((L1+1)*8)^1.125)*SIGN(L1)+[@M1*3)/8+((N1+1)*(O1/4+P1+... and so on.

    Each plus sign is a "step in the equation" where I'd like to display the result.

    A LET function? Index?

    Thanks!
    Last edited by CVDom; 04-08-2024 at 10:46 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SPILL arrays multi-column SUMIFS and countif - rearranging columns
    By Glenn Kennedy in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 08-12-2022, 01:56 PM
  2. [SOLVED] Multi criteria INDEX/MATCH in multi-column FILTER spill range
    By Coley356 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2021, 04:23 PM
  3. [SOLVED] Return MAX (or LARGE) for each 2D array's row with only ONE "spill" formula
    By leolapa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-22-2021, 08:50 AM
  4. WPS Office: How to call a multi-step formula like a subroutine
    By martik777 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 07-31-2021, 01:41 AM
  5. How to call a multi-step formula like a subroutine
    By martik777 in forum Excel General
    Replies: 6
    Last Post: 07-31-2021, 01:41 AM
  6. Multi-step formula to return increment pay rise
    By Kevy_M in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-23-2013, 10:31 PM
  7. Need help: Macro or multi-step formula needed in place of a pivot-table method.
    By katiedegu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2013, 10:29 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