SOLVED

if function help needed

%3CLINGO-SUB%20id%3D%22lingo-sub-1387210%22%20slang%3D%22en-US%22%3Eif%20function%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1387210%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20everyone%20in%20the%20forum%20is%20safe%20and%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENeed%20help%20with%20multiple%20if%20conditions.%20Please%20see%20the%20attachment%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%20I%20am%20using%20office%202016%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20help%20this%20is%20very%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1387210%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1387284%22%20slang%3D%22en-US%22%3ERe%3A%20if%20function%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1387284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566622%22%20target%3D%22_blank%22%3E%40rakeshtalwar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20put%20multiple%20conditions%2C%20use%20AND%20function%20%2C%20similarly%20there%20is%20one%20OR%20function%20also%20%2C%20pls.%20try%20to%20learn%20about%20these%20how%20these%20functions%20work%20using%20Help%20of%20EXCEL%20or%20other%20internet%20sources..%3C%2FP%3E%3CP%3EAlso%2C%20you%20can%20use%20an%20IF%20inside%20another%20IF%20too..%3C%2FP%3E%3CP%3ESo%2C%20for%20your%20present%20case%20%2C%20here%20is%20how%20you%20would%20apply%20it%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3DIF(AND(C2%3D0%2CD2%3D0)%2C%22Please%20Choose%201%22%2CIF(AND(C2%26gt%3B0%2CD2%3D0)%2C%22Nestila%20Lite%22%2CIF(AND(C2%3D0%2CD2%26gt%3B0)%2C%22Nestila%20ECO%22%2CIF(AND(C2%26gt%3B0%2CD2%26gt%3B0)%2C%22ECO%20Lite%22%2C%22%22))))%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi All, 

 

I hope everyone in the forum is safe and fine.

 

Need help with multiple if conditions. Please see the attachment 

Please note I am using office 2016 

 

 

please help this is very 

1 Reply
Highlighted
Best Response confirmed by rakeshtalwar (Occasional Contributor)
Solution

@rakeshtalwar 

 

To put multiple conditions, use AND function , similarly there is one OR function also , pls. try to learn about these how these functions work using Help of EXCEL or other internet sources..

Also, you can use an IF inside another IF too..

So, for your present case , here is how you would apply it :-

 

=IF(AND(C2=0,D2=0),"Please Choose 1",IF(AND(C2>0,D2=0),"Nestila Lite",IF(AND(C2=0,D2>0),"Nestila ECO",IF(AND(C2>0,D2>0),"ECO Lite",""))))