+ Reply to Thread
Results 1 to 3 of 3

Need a single formula for multi condition remark.

  1. 04-07-2020, 07:10 AM #1
    Pankaj jaswani
    Pankaj jaswani is offline
    Forum Contributor
    Join Date
    07-27-2018
    Location
    Jodhpur, India
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 Pro 64-bit)
    Posts
    405

    Need a single formula for multi condition remark.

    Hi,

    I have a table data where I want a single remark of the working status in a single column based on multi-condition/criteria. Please help me with this.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-07-2020, 07:54 AM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Need a single formula for multi condition remark.

    Please try at G5
    =IF(D5="",IF(EDATE(C5,2)>TODAY(),"New Joinee","Regular"),"Attrition")
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 04-07-2020, 09:37 AM #3
    Pankaj jaswani
    Pankaj jaswani is offline
    Forum Contributor
    Join Date
    07-27-2018
    Location
    Jodhpur, India
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 Pro 64-bit)
    Posts
    405

    Re: Need a single formula for multi condition remark.

    Bo_Ry Bro! It is working fine. Thanks a lot.
    Last edited by AliGW; 04-07-2020 at 09:44 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multi condition formula to show attendance between two dates between times of a given date
    By annazet in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-06-2019, 06:27 AM
  2. [SOLVED] Multi-Condition Group-Based Addition Formula
    By ChrisHook in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2019, 04:07 PM
  3. [SOLVED] multi pal condition in single row
    By arindamsenaxa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-04-2018, 12:55 AM
  4. [SOLVED] Formula for today remark
    By mukeshbaviskar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2014, 11:31 AM
  5. List Data from Cells in a single Table Row into a multi-column and multi-row Range.
    By Asaan in forum Excel General
    Replies: 19
    Last Post: 10-05-2012, 01:03 PM
  6. Multi-condition if formula
    By sayow55 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2011, 06:23 PM
  7. Multi Condition Formula
    By klatre in forum Excel General
    Replies: 0
    Last Post: 07-29-2010, 12:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1