Results 1 to 3 of 3

Create "IF" formula to generate different results based on values in multiple rows

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    detroit
    MS-Off Ver
    Excel 2007
    Posts
    14

    Create "IF" formula to generate different results based on values in multiple rows

    Hello friends,
    I need to write a formula to process the following can you please help
    if column k (where k = status) is not populated, and column h (where h = date) is > than todays date,
    then column j = Behind Schedule if column h is not populated, then column j = Not reported

    Can you please help me convert this into a formula. Can I used "If" formula for this. I tried a couple of times but it did not work

    Please help.
    Thank you
    Last edited by abhinavn; 09-29-2010 at 03:33 PM. Reason: Title not in compliance with rules

Thread Information

Users Browsing this Thread

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

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