Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Nested IFs in query editor

Hi All,   Need your help in writing below formula from excel in custom column:   =IF(A2="AMS",IF(TIME(HOUR(B2),MINUTE(B2),SECOND(B2))>10:30:00 PM,DATE(YEAR(B2),MONTH(B2),DAY(B2))+1+11:30:00 AM+4:...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi  Anonymous,

     

    It seems that you are looking for how to add the conditional column.

     

    You could try the following way which is much easier, you don't need to write the expression.

     

     

     

    Best Regards,

    Cherry

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi v-piga-msft,

     

    Thank you for your suppoert. I did a work around and then break the query in 2 parts and then applied conditional formatting.

     

    it worked for me.

     

     

    Thanks for your help.

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi  Anonymous,

 

It seems that you are looking for how to add the conditional column.

 

You could try the following way which is much easier, you don't need to write the expression.

 

 

 

Best Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-piga-msft,

 

Thank you for your suppoert. I did a work around and then break the query in 2 parts and then applied conditional formatting.

 

it worked for me.

 

 

Thanks for your help.