Results 1 to 3 of 3

Need correct if() formula

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2008
    Posts
    65

    Need correct if() formula

    I want to use IF() condition in the ExampleS.xlsx file i have attached.

    The result must be displayed in D column(Eligible Yes/No).

    i want that if Days present is greater than or equal to 18 AND NCNS is 0 than the answer must be Yes. But if days present is less than 18 AND/OR NCNS is greater than 0 than answer must be No. If either of the condition is false then also answer must be No.
    Attached Files Attached Files

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