Closed Thread
Results 1 to 2 of 2

Multiple True instructions for one If

  1. #1
    Registered User
    Join Date
    06-03-2020
    Location
    World
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (16.0.12730.20342) 64-bit
    Posts
    7

    Post Multiple True instructions for one If

    I am struggling to figure this out. The scenario looks like this: Two columns with start and end date is present. I created 3rd to find the number of days. Pretty simple. But, when I did this, surprisingly, I got negative results for few rows meaning that some entries had end date before the starting date and this is serious mistake. So, what I was thinking of doing was to change the entries with negative results to "0" and mark the cell as red for reference to wrong entry. To do this, I have to check whether the cell value is less than 0. If TRUE, then assign value zero and fill the cell with red color but I am stuck here.

    Any help will be great.
    Last edited by AliGW; 06-04-2020 at 12:51 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,640

    Re: Multiple True instructions for one If

    Administrative Note:

    Welcome to the forum.

    Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

    With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

    Thank you for helping us to help you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Multiple "Worksheet Change" Instructions
    By jonurquhart in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-16-2019, 10:36 AM
  2. Replies: 1
    Last Post: 06-26-2019, 09:25 AM
  3. [SOLVED] Lookup multiple criteria in multiple columns in multiple rows; return true if exists
    By ufdlim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2019, 02:03 PM
  4. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  5. Replies: 2
    Last Post: 06-06-2012, 07:12 AM
  6. Loan Calculator with Terms based on Fixed Payment not a fixed time frame.
    By cc4digital in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2012, 04:49 AM
  7. Replies: 2
    Last Post: 11-22-2011, 12:33 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