+ Reply to Thread
Results 1 to 2 of 2

Need help with formula that the end result is contingent on info from 2 cells

  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    Nashville, TN
    MS-Off Ver
    2010
    Posts
    1

    Need help with formula that the end result is contingent on info from 2 cells

    I am trying to create a formula that will automatically populate a statement in Column E but conditions are based on information in columns C & D. This is what I want to be in Column E: =IF(D3=>0,"Y","Pend").

    However, the information in column C determines if the statement in Column E is necessary. I want to create the statement to read if there is nothing in Column C, then leave Column E blank.

    I am using Column C as a input Cell and the formula in Column D is (Column B-Column C). If I have not input anything in Column C, then there is no need for the pending or yes statement in Column E.

    This involves 2 conditions, I'm thinking "If and "AND" but when I tried to add them together using the following formula but it was incorrect:
    =IF(D3=>0,"Y","Pend"), AND(C3>0)).

  2. #2
    Forum Contributor
    Join Date
    01-30-2013
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    231

    Re: Need help with formula that the end result is contingent on info from 2 cells

    In E3

    if(C3="","",if(D3=>0,"Y","Pend))
    Click * below if this answer helped

+ 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. formula that gets info from other cells to get a result
    By deonderd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2013, 02:56 PM
  2. Disable cells contingent on an option button
    By jghender in forum Excel General
    Replies: 0
    Last Post: 12-27-2012, 06:10 PM
  3. Replies: 3
    Last Post: 09-22-2011, 03:59 PM
  4. Replies: 3
    Last Post: 04-15-2010, 08:36 PM
  5. Replies: 1
    Last Post: 06-12-2008, 09:16 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