+ Reply to Thread
Results 1 to 2 of 2

Need help programming in excel

  1. #1
    Registered User
    Join Date
    11-30-2014
    Location
    Indiana
    MS-Off Ver
    Open Office
    Posts
    1

    Red face Need help programming in excel

    Trying to track re admittance of patients:

    I created a formula in a cell that deducts one date from another. I'm trying to create a cell that will then take that data and if it's less than 30 days or greater than 0 days it comes back with a Yes output. AND or I want it to only populate a YES if that field is <30 days but if there is no data in the field to just leave the cell blank.

    I've tried the IF function and can get it to calculate the YES but when I tried to figure out how to get the cells with no data to read blank I'm STUCK.

  2. #2
    Forum Contributor
    Join Date
    02-24-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    317

    Re: Need help programming in excel

    It's kind of hard to pinpoint what you want without seeing your original formula or a sample of your spreadsheet, but maybe this?

    Assuming that the cell that contains no data is B2, try adding this bit to the beginning of your formula;
    Please Login or Register  to view this content.
    If I helped in any way, please click the star

+ 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. New to Excel Programming
    By congee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2013, 06:17 PM
  2. Replies: 1
    Last Post: 08-20-2012, 01:13 PM
  3. GET Excel Programming
    By ramakanta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2009, 02:20 AM
  4. [SOLVED] Help for Programming in Excel
    By kaci in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2006, 12:10 AM
  5. Excel Vba Programming
    By kamakshi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2005, 11:05 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