Results 1 to 19 of 19

Can you shorten a LONG formula?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-19-2020
    Location
    SE-Asia
    MS-Off Ver
    2019
    Posts
    104

    Can you shorten a LONG formula?

    This is a part of a (LONG) Function

    H8+(2*I8)+L8+M8+N8+O8+P8+(2*Q8)+(2*R8)+(2*S8)
    Is there way to Shorten this?

    This Function (formula) is then copied all the way down

    TiA

    Ps: Please a hint first instead of the "pre-cooked" solution
    Last edited by iammike; 04-15-2024 at 09:37 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Shorten Long Formula
    By fastcar in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-20-2020, 02:41 PM
  2. shorten very long formula
    By dioxide in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-22-2019, 06:58 PM
  3. How to use AND & IF and shorten a long formula
    By VisionSmart in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-16-2019, 06:45 AM
  4. [SOLVED] How to shorten Too Long Countif formula
    By putraguevara in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-10-2019, 04:12 PM
  5. Long formula, need to shorten
    By BlairStevenson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-06-2014, 12:23 PM
  6. [SOLVED] Too Long formula to shorten help
    By lapot in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-14-2014, 07:51 AM
  7. [SOLVED] Shorten a very long Formula
    By Floydlevedale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2013, 09:39 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