Before follow this video tutorial you should have to follow my previous tutorials for your best knowledge....
• Excel Nested IF function || Bengali langua...
In this video tutorial I have discuss some advance level of IF function. This tutorial help you to check multiple condition and get multiple true value, but false value will show always once. I suggest you follow my tutorial and create the table, you may copy my formula and paste your table :
=IF(AND(B3 greater and =80,B3 lesser and =100),"A",IF(AND(B3 greater and =50,B3 lesser and =79),"B",IF(AND(B3 greater and =0,B3 lesser and 50),"Candidate not to be qualified","Please input the marks 0 to 100")))
NB : “greater and”, “lesser and” changed by the symbol, as per youtube norms I can’t use the symbol.
At first start any if function,then apply the AND function. Under the AND function bracket apply different "LOGIC" , like "logic1, logic2,.......etc.If two or more logic tests are satisfy or true,then first true value will show. If first IF function not satisfy then goto to the second IF function and check second IF function different logic's , if satisfy then show the second true value. As like as check more then IF function and check different logic's. After that, if any IF function not satisfy then show the false value.
For more update yourself subscribe my channel and click bell.
You may also my contact to my other social media websites like -
LinkedIn - / sidhartha. .
Facebook - / sid.rockstar.16
Instagram - https://www.instagram.com/sidharthapa...
To subscrive my channel :
/ @edutechitacademy
#ifStatementBangla, #banglaTutorialExcel, #banglaIFTutorialMsExcelUsingAND, #banglaExcel, #ExcelBanglaTutorial, #ExcelTutorialBangla, #ExcelTutorial, #FreeExcelCourse, #LearnExcel, #FreeTutorial, #msExcel, #microsoftExcelTutorial, #howToUseIfFunctionInMsExcel, #usingIfFunction, #howToUseIfFunctionInMsExcelBangla, #useIfFunctionExcel, #ifFunctionExcelGreaterThan, #excelLogicalFunctions, #howToUseIfANDFunctionInExcel, #ifFunctionInMicrosoftOfficeExcel2007 #EITA
You may also learn WebDesign from this channel :
/ @bubai_creation
Информация по комментариям в разработке