Results 1 to 4 of 4

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

Threaded View

  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

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