+ Reply to Thread
Results 1 to 4 of 4

IF formula to equal the value of the cell if it doesn't meat the criteria

  1. #1
    Registered User
    Join Date
    10-18-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    11

    IF formula to equal the value of the cell if it doesn't meat the criteria

    I require some assistance on writing the following formula.

    I have a figure that is in column D that comes from a pivot table. I have formulas in column E that give the final value.

    If the value of the cell in column D is under 16 then the figure in the cell in column E is to show "16"
    If the value of the cell in column D is over 16 then the figure in the cell in column E is to show what the value in column D is.

    I have started the formula as shown below but need to know what I need to write to complete the formula if the value is over 16.

    =IF(D77<16,"16")

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

    Re: IF formula to equal the value of the cell if it doesn't meat the criteria

    Try

    =MAX(16,D77)

  3. #3
    Registered User
    Join Date
    10-18-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    11

    Re: IF formula to equal the value of the cell if it doesn't meat the criteria

    Thanks for youe assistance. The formula works great.

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

    Re: IF formula to equal the value of the cell if it doesn't meat the criteria

    You're welcome.

+ 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. [SOLVED] Formula to show data if cell doesn't equal zero
    By heytherejem in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-31-2017, 01:22 PM
  2. [SOLVED] Counting if date cell doesn't equal blank
    By NovaExcelGuy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-26-2014, 10:55 AM
  3. [SOLVED] SumIfs Formula With Multiple Not Equal To Criteria
    By zmster2033 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-07-2014, 05:08 PM
  4. Don't understand why formula doesn't equal zero
    By TimeMachine in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-23-2013, 10:56 PM
  5. [SOLVED] COUNTIF Formula with DOES NOT EQUAL TO operator doesn't work
    By JPWRana in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-20-2013, 06:10 PM
  6. Replies: 0
    Last Post: 11-17-2010, 12:02 PM
  7. Formula bar doesn't have an equal sign
    By Joes Auto Pat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2006, 03:10 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