+ Reply to Thread
Results 1 to 4 of 4

IF Statement which includes an outcome only if specific criteria are met

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    5

    IF Statement which includes an outcome only if specific criteria are met

    I have a spreadsheet in which I have a IF statement which provides specific values when it's true and another if it's false. However, I only want to see the false outcome in the cell if the value is a negative number. I'm sure this is super easy for someone else, however as a novice, it's kicking my behind. I have attached the spreadsheet example. The cell I am formatting are starting with E35 based on the value in cell E29. If the value in cell E29 is a negative I want to see that value in E23, if the value in cell E23 is 0 or a positive number I just want to see 0. Thanks for any assistance!Attachment 282309

    disregard the workbook ss and use only Angie's ss for this problem!
    Attached Files Attached Files
    Last edited by lynnepooh; 12-06-2013 at 09:51 AM. Reason: Wrong file was input

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: IF Statement which includes an outcome only if specific criteria are met

    Sorry, this is a little confusing. Are you sure that the cell references in your question match what is actually in the file?

    You have the following formula in E35:

    =IF(E29<0,0,E29)

    This seems to do what the first two sentences of your post describe. Then you said

    If the value in cell E29 is a negative I want to see that value in E23

    But E23 is an empty cell. How would expect to see anything at all in E23? Then you said

    if the value in cell E23 is 0 or a positive number I just want to see 0

    Where do you want to see that 0 in the case that E23>=0? You don't have a formula anywhere in this sheet that refers to E23.

    I am sure that what you need is simple, but I think you just need a little clarity on what you want to do. Perhaps as a novice some of the confusion is about how formulas work. A formula returns a value which is shown in the cell where it is entered. A formula in one cell can't place a value into a different cell.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-20-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: IF Statement which includes an outcome only if specific criteria are met

    Sorry, I meant I want to see the value in E29 I just typed in the wrong number! If the value in E29 is a negative number I want to see it appear in cell E35. If the value in E29 is a 0 or a positive number I just want 0 to be the outcome in cell E35. Make more sense now?

  4. #4
    Registered User
    Join Date
    11-20-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: IF Statement which includes an outcome only if specific criteria are met

    Figured it out! Thanks for all those who took a look!

+ 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. If statement outcome problem
    By devilchild99 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2013, 09:25 PM
  2. [SOLVED] Find a number closest to 30 in a range with one more criteria (criteria includes text)
    By Sarangsood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2013, 01:16 PM
  3. [SOLVED] issue with outcome of if/then statement in VBA
    By Marijke in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2013, 10:18 AM
  4. [SOLVED] Counting Cells that includes exact match and also if a cell includes specific text
    By smclachlan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2012, 07:42 PM
  5. [SOLVED] How to calculate a sum as one outcome of an IF statement
    By barb in NC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2005, 03:06 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