Results 1 to 6 of 6

using IF function to use different formulas depending on different rules

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2013
    Location
    Chesham
    MS-Off Ver
    Excel 2010
    Posts
    33

    using IF function to use different formulas depending on different rules

    Hi,

    I have got to this stage with a formula but cannot understand why it isn't working:

    =IF(OR(A2=1,A2=2),(MIN(B2:B6)+50),(MAX(B2:B6)+50))

    If A2 equals 1, I want it to add 50 on to the smallest (earliest) date in C2:C5.

    BUT

    If A2 equals 2, I want it to add 50 on to the largest (latest) date

    The formula just adds 50 on the smallest (earliest) date, whether A2 equals 1 or 2.

    What am I doing wrong?

    Any help or advice would be much appreciated.

    Toby
    Last edited by Tnashnhsp1; 11-27-2013 at 11:35 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  2. [SOLVED] Using Offset function as the array in the PercentRank function is giving wrong result
    By Bobneil in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 09:29 PM
  3. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  4. Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  5. Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 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