+ Reply to Thread
Results 1 to 3 of 3

Shorter substitute formula in excel

  1. #1
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Shorter substitute formula in excel

    hi guys,

    how can i shorter this formula?
    it's working fine, but it seems too big, or is this okay to keep it as it is?
    please advise.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Shorter substitute formula in excel

    Please attach the excel file so that I can understand it more clearly

  3. #3
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: Shorter substitute formula in excel

    Quote Originally Posted by azumi View Post
    Please attach the excel file so that I can understand it more clearly
    Here enclosed
    Attached Files Attached Files

+ 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. SUM, IF, FREQUENCY formula count instances of sick time off [shorter formula?]
    By paulanderson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2020, 05:01 PM
  2. [SOLVED] If formula need be shorter
    By nur2544 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2017, 06:27 AM
  3. Replies: 8
    Last Post: 05-14-2013, 12:36 AM
  4. Excel 2003 - VBA to substitute value from cell in formula
    By Belgarath75 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2013, 06:51 AM
  5. How to use a substitute formula to substitute text entries to a different text entry
    By andybocchi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-01-2010, 07:50 PM
  6. Shorter formula
    By fivermsg in forum Excel General
    Replies: 3
    Last Post: 01-03-2008, 04:55 PM
  7. [SOLVED] Shorter Formula
    By Pete in forum Excel General
    Replies: 2
    Last Post: 02-18-2005, 12:06 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