Forum Discussion

Saravanan_ameer's avatar
Saravanan_ameer
Frequent Visitor
3 years ago
Solved

Applying 2 conditions to create the column

Hi All,

 

I have the data of the employees login, log out timing details, gender details.

 

I want to create the column as per the below conditions

 

If Emp Gender Is M and Log out time is before 3.30 pm then mark it as Early 

If Emp Gender Is F and Log out time is before 3.20 pm then mark it as Early 

OR ELSE Normal

 

i am able to apply any one if condition not able to apply 2 conditions.

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Saravanan_ameer ,

     

    Please find the below solution.

    Flag = IF(Sheet1[log out]<3.30 && Sheet1[Gender]="M","Early",IF(Sheet1[log out]<3.20 && Sheet1[Gender]="F","Early","Normal"))
     

     

    Best Regards,

    Shreya Mukkawar

    If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly.

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Saravanan_ameer ,

     

    1. Create a column time.

    time = IF(Sheet1[Gender]="M",3.30-Sheet1[log out],IF(Sheet1[Gender]="F",3.20-Sheet1[log out])
    2. Create a column flag 2
    Flag 2 = IF(Sheet1[Flag]="Early",Sheet1[time])
     

    Best Regards,

    Shreya Mukkawar

    If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly and Like the solution.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Saravanan_ameer ,

     

    Please find the below solution.

    Flag = IF(Sheet1[log out]<3.30 && Sheet1[Gender]="M","Early",IF(Sheet1[log out]<3.20 && Sheet1[Gender]="F","Early","Normal"))
     

     

    Best Regards,

    Shreya Mukkawar

    If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly.

    • Saravanan_ameer's avatar
      Saravanan_ameer
      Frequent Visitor
      3 years ago

      Thanks for reply i need one more column that late by hh:mm which is for the Female how many hours they logout before 3.20 and also for Male before 3:30 how many hours

       

      ex: The female is logout by 3 pm so she departure early by 0:20 and if the male is logged out by 3 pm so the value should reflect as 0:30 (I need it both in single column)

       

      plesase help

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Saravanan_ameer ,

         

        1. Create a column time.

        time = IF(Sheet1[Gender]="M",3.30-Sheet1[log out],IF(Sheet1[Gender]="F",3.20-Sheet1[log out])
        2. Create a column flag 2
        Flag 2 = IF(Sheet1[Flag]="Early",Sheet1[time])
         

        Best Regards,

        Shreya Mukkawar

        If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly and Like the solution.