+ Reply to Thread
Results 1 to 4 of 4

Simplify the formula

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    jakarta
    MS-Off Ver
    2007
    Posts
    95

    Simplify the formula

    Is there any formula that could be shorter than this..?
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I know that this formula looks very simple if it just be like it, but I'm just using this formula for an example of my problem..
    As you can see, if I change the 'Sheet!B4' on logical_test part with other complicated and long formula, then I should write it again on [value_if_false] part right..?

    that's make my formula become very long..
    And it would take a very long time to saving my file that contained some of this formula..
    Will someone help me to simplify my formula please..?
    Thanks for the attention..
    I really appreciate it..

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,699

    Re: Simplify the formula

    Try using MAX, i.e.

    =MAX(Sheet2!B4,0)
    Audere est facere

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Simplify the formula

    It's usually best to post your actual formula, not a simplified example
    The solution to the simplified version is often not easily translated to the real version

    That said, you can use the max function

    =MAX(Sheet2!B4,0)

  4. #4
    Registered User
    Join Date
    07-15-2013
    Location
    jakarta
    MS-Off Ver
    2007
    Posts
    95

    Re: Simplify the formula

    Thanks for the help guys..
    I've used the function and it's working good on my work..
    But I don't know why, I still need to wait for a long time each time I save my file..
    I wonder what went wrong on my workbook..?

+ 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. Help simplify my formula!
    By missxmelon in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-23-2013, 04:24 PM
  2. Simplify a Formula
    By samsnb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-25-2013, 03:38 PM
  3. Simplify formula
    By SalamanderSam14 in forum Excel General
    Replies: 6
    Last Post: 01-04-2012, 12:23 PM
  4. How to simplify this formula
    By jake21ph in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-15-2011, 05:00 AM
  5. How to simplify this IF formula
    By Bojana in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2005, 12:03 PM

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