Expression

[Mouldi_Zeghouan]

Hi,

I have two virtual columns showing percentage difference:

 1- Virtual column L1 (percentage weight difference)

2-Virtual column L2 (percentage item difference)

My question is that I want the expression that  shows Yes or No in the virtual column Status, depending on the condition:(L1>1%,L1<-1%,L2>3%,L2<-3%),"Y","N" 

Please advise

[Marc_Dillon]

https://help.appsheet.com/en/articles/961337-yes-no-expressions

[Mouldi_Zeghouan]

Thank you for your reply, I checked the article for the yes-no expressions and tried many expressions but none of them working for me.

This my format in Excel: =IF(OR(L1>1%,L1<-1%,L2>3%,L2<-3%),"Y","N") and it is working fine.

Do you have any idea on how to convert the Excel format to appsheet expression.

Thanks