https://community.qlik.com/t5/App-Development/If-statement-with-multiple-conditions/m-p/1985860#M81402 <P>Hello,</P> <P>How can I write the following excel formula with qlik? Thank you</P> <P>=IF(AND(G3=0;H3=0;I3=0);0;G3/(G3+H3+I3))</P> Tue, 27 Sep 2022 08:37:56 GMT OnurT 2022-09-27T08:37:56Z https://community.qlik.com/t5/App-Development/If-statement-with-multiple-conditions/m-p/1985860#M81402 <P>Hello,</P> <P>How can I write the following excel formula with qlik? Thank you</P> <P>=IF(AND(G3=0;H3=0;I3=0);0;G3/(G3+H3+I3))</P> Tue, 27 Sep 2022 08:37:56 GMT https://community.qlik.com/t5/App-Development/If-statement-with-multiple-conditions/m-p/1985860#M81402 OnurT 2022-09-27T08:37:56Z https://community.qlik.com/t5/App-Development/If-statement-with-multiple-conditions/m-p/1985870#M81404 <P>Hi, something like this:</P> <P>IF( G3=0 and H3=0 and I3=0 , 0, G3/(G3+H3+I3) )</P> <P>You can take a look at Qlik help for more understanding:</P> <P><A href="https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/if.htm" target="_blank">https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/if.htm</A></P> Tue, 27 Sep 2022 08:48:59 GMT https://community.qlik.com/t5/App-Development/If-statement-with-multiple-conditions/m-p/1985870#M81404 justISO 2022-09-27T08:48:59Z https://community.qlik.com/t5/App-Development/If-statement-with-multiple-conditions/m-p/1985969#M81422 <P>thank you</P> Tue, 27 Sep 2022 11:53:22 GMT https://community.qlik.com/t5/App-Development/If-statement-with-multiple-conditions/m-p/1985969#M81422 OnurT 2022-09-27T11:53:22Z