https://community.qlik.com/t5/Management-Governance/Excel-formula-in-Qliksense/m-p/2115787#M25624 <P>Hi,</P> <P>Try below</P> <P><SPAN>=if(A4=A3 and C4-C3 &lt;=1, '1DR','Unique')</SPAN></P> <P>&nbsp;</P> Tue, 12 Sep 2023 06:26:38 GMT PrashantSangle 2023-09-12T06:26:38Z https://community.qlik.com/t5/Management-Governance/Excel-formula-in-Qliksense/m-p/2115784#M25623 <P>Hi , I want to replicate the below excel formula in Qliksense. can anyone pl help ?</P> <P>' =IF(AND(A4=A3,C4-C3&lt;=1),"1DR","Unique") '</P> Tue, 12 Sep 2023 06:14:08 GMT https://community.qlik.com/t5/Management-Governance/Excel-formula-in-Qliksense/m-p/2115784#M25623 A_M 2023-09-12T06:14:08Z https://community.qlik.com/t5/Management-Governance/Excel-formula-in-Qliksense/m-p/2115787#M25624 <P>Hi,</P> <P>Try below</P> <P><SPAN>=if(A4=A3 and C4-C3 &lt;=1, '1DR','Unique')</SPAN></P> <P>&nbsp;</P> Tue, 12 Sep 2023 06:26:38 GMT https://community.qlik.com/t5/Management-Governance/Excel-formula-in-Qliksense/m-p/2115787#M25624 PrashantSangle 2023-09-12T06:26:38Z