+ Reply to Thread
Results 1 to 2 of 2

Asking formula in IF and bringing back same formula as one of results

  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Asking formula in IF and bringing back same formula as one of results

    Hey,

    A regular problem I have when writing huge formulas is that I want to add an IF to the entire formula, and if true, bring back a result, and if false, bring back the result of the IF criteria. The problem with this is the criteria in question could be 20 lines long, which then means I need to double my formula size to 40 lines. Is there anyway to do this...hope this makes sense???

  2. #2
    Registered User
    Join Date
    04-18-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Asking formula in IF and bringing back same formula as one of results

    so an example could be:

    =if(<massive formula>="Yes", "OK",<massive formula>)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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