2. Logical Function: Use And OR Function in Excel Bangla Adv Level || Mamun Academy

2. Logical Function: Use And OR Function in Excel Bangla Adv Level || Mamun Academy

Microsoft Excel provides 4 logical functions to work with the logical values. The functions are AND, OR, XOR and NOT. You use these functions when you want to carry out more than one comparison in your formula or test multiple conditions instead of just one. As well as logical operators, Excel logical functions return either TRUE or FALSE when their arguments are evaluated.
The OR function is a logical function to test multiple conditions at the same time. OR returns either TRUE or FALSE.
The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.

The Microsoft Excel OR function is a logical function in excel to test different conditions in the meantime. This logical function helps you in comparing two values or statements in excel. OR in Excel, on the other hand, returns either TRUE or FALSE. OR function will return TRUE if at least any one of the arguments or conditions evaluates as TRUE. Similarly, it will also return FALSE, if all the arguments or conditions are FALSE. The OR in Excel can be utilized as the logical test inside the IF function for avoiding extra nested IFs and can be also be used in combination with the AND function.

=IF(Something is True, then do something, otherwise do something else)
Here are overviews of how to structure AND, OR and NOT functions individually. When you combine each one of them with an IF statement, they read like this:

AND – =IF(AND(Something is True, Something else is True), Value if True, Value if False)

OR – =IF(OR(Something is True, Something else is True), Value if True, Value if False)


I think you have enjoyed this video.

If this tutorial really helps you, please like, comment, subscribe and share with your close friends. This is #and #or #logical #mamunacademy


............................................................................
..............Subscribe to Get More Videos...........
https://www.youtube.com/c/MaMuNAcadem...
............................................................................

..................................................................................................
Most Favorite Videos

আমার ভিডিও /টিউটোরিয়াল কোথা থেকে শুরু করবেন ?
   • How  My Tutorial Arranged_About MamuN...  


MS Excel Bangla Tutorial Playlist :

Excel Super Secret Tips & Tricks: https://goo.gl/5qSphJ
Mastery of If Function Bangla: https://goo.gl/jY76m4
MS Excel Essential Course : https://goo.gl/7EX1hk
MS Excel Intermediate Course: https://goo.gl/iatnNz
MS Excel Advanced Course: https://goo.gl/WFrvzU
MS Excel Formulas & Functions: https://goo.gl/7Da7oZ
MS Excel Pivot Table Magic: https://goo.gl/NGp13W
MS Word Essential Course: https://goo.gl/SVXefG
Magic of Conditional Formatting Bangla : https://goo.gl/j4N3sH
Mastery of VLOOKUP Function : https://goo.gl/1YAZ5y
Result Sheet Making Bangla : https://goo.gl/VnuZk6
Salary Sheet Making Hidden Tricks : https://goo.gl/KXsfyh
Master of Pivot Table : https://goo.gl/PaGUzj
MS Word Magic and Tips and Tricks : https://goo.gl/6b25kB
MS PowerPoint 2019 Bangla: https://goo.gl/eoeeMm
..................................................................................................


.................Social Media.................


Twitter :   / cumamun  
Google+ : https://plus.google.com/mamunacademy
LinkedIn :   / abdulla-al-mamun-172629b4  
Instagram:   / al-mamun36  

..............................................

........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & http://www.bensound.com

Intro/Outro/Banner Creator:
Official™ ► http://bit.ly/OffTMDesigns
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................


Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks. .
.................................................................................................

.................Social Media.................
Facebook Page :   / mamunacademy4u  
Facebook Group :   / mamunacademy  
Google+ : https://plus.google.com/mamunacademy
LinkedIn :   / abdulla-al-mamun-172629b4  
..............................................

........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & http://www.bensound.com

Intro/Outro/Banner Creator:
Official™ ► http://bit.ly/OffTMDesigns
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................

Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks.