+ Reply to Thread
Results 1 to 7 of 7

Formula To Check if one cell value is greater then populate another cell

  1. #1
    Forum Contributor
    Join Date
    02-23-2014
    Location
    Melbourne
    MS-Off Ver
    Microsoft 365
    Posts
    174

    Formula To Check if one cell value is greater then populate another cell

    Hello Experts
    I am wondering if what I need is possible using a formula in excel

    I have attached a screen capture and the excel file as it is easier to explain than typing the info here

    Need a formula in D9 which if E9 is greater than B9. Value in E9 is copied to D9
    But if the value of B9 is greater than E9.
    It adds B9+C9 & puts that value in D9

    Please help

    Regards
    Rahul
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula To Check if one cell value is greater then populate another cell

    Quote Originally Posted by rahul_ferns76 View Post
    Need a formula in D9 which if E9 is greater than B9. Value in E9 is copied to D9
    But if the value of B9 is greater than E9.
    It adds B9+C9 & puts that value in D9
    What if B9 equals E9?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Formula To Check if one cell value is greater then populate another cell

    Try

    =IF(E9>B9,E9,IF(B9>E9,B9+C9,"???"))

    The ??? needs replacing with result if equal (as per by Tony's response).
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    02-23-2014
    Location
    Melbourne
    MS-Off Ver
    Microsoft 365
    Posts
    174

    Re: Formula To Check if one cell value is greater then populate another cell

    Hi Tony
    Then it should display the value in E9

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Formula To Check if one cell value is greater then populate another cell

    This ..

    =IF(E9>B9,E9,IF(B9>E9,B9+C9,E9))

  6. #6
    Forum Contributor
    Join Date
    02-23-2014
    Location
    Melbourne
    MS-Off Ver
    Microsoft 365
    Posts
    174

    Re: Formula To Check if one cell value is greater then populate another cell

    Hi John & Tony
    That works like a charm

    After looking at the solution

    I feel like wow that such a simple logic. If only I could worked it out myself

    But I am learning a lot using this forum
    Thanks guys

    Rahul

  7. #7
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula To Check if one cell value is greater then populate another cell

    You're welcome. Thanks for the feedback!

+ 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. Have default formula populate a cell before user interacts with a check box
    By apostrophe27 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-17-2016, 10:51 AM
  2. Formula to Determine if Date in Cell 2 is Greater Than Cell 1
    By MLCall in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-18-2014, 05:30 PM
  3. [SOLVED] Populate a cell if another cell is greater than or equal to a third cell.
    By Tazyote in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-20-2014, 02:51 PM
  4. [SOLVED] Formula to check two cells greater than one other cell
    By FIFTYFINGERS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2012, 03:03 PM
  5. Replies: 2
    Last Post: 10-16-2012, 01:27 PM
  6. Replies: 2
    Last Post: 02-20-2012, 05:48 PM
  7. Check a cell's value and populate other cells with varying data
    By Demosthenes&Locke in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2010, 07:48 AM

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