If Function in Ms excel | How to Use IF Function in Excel | Google sheets | MS excel tutorial Bangla
Online live class link :
https://sites.google.com/view/tanvira...
Download working file from below link :
https://docs.google.com/spreadsheets/...
The IF function in both Excel and Google Sheets is used to perform conditional logic. It allows you to make decisions based on whether a specified condition is true or false. Here's a step-by-step guide on how to use the IF function in both Excel and Google Sheets:
Using IF Function in Microsoft Excel:
Syntax:
=IF(logical_test, value_if_true, value_if_false)
logical_test: The condition you want to test.
value_if_true: The value to return if the logical test is true.
value_if_false: The value to return if the logical test is false.
Example:
Let's say you have a list of exam scores in column A, and you want to label each score as "Pass" if it's greater than or equal to 60, and "Fail" if it's less than 60.
=IF(A1 is greater than equal to 60, "Pass", "Fail")
Drag this formula down for other cells to apply the same logic to the entire column.
Using IF Function in Google Sheets:
Syntax:
=IF(logical_test, value_if_true, value_if_false)
The syntax is the same as in Excel.
Example:
Using the same scenario as before, if you're working in Google Sheets, the formula would look exactly the same:
excel
Copy code
=IF(A1 is greater than equal to 60, "Pass", "Fail")
Enter this formula in a cell, and it will perform the same logic as in Excel.
How to Enter the Formula:
Excel:
Click on the cell where you want the result.
Enter the formula.
Press Enter.
Google Sheets:
#googlesheetstutorial
#msexcelfullcourse
#msexcel
Click on the cell where you want the result.
Enter the formula.
Press Enter.
Video Tutorial:
If you prefer a visual guide, you can search for IF function tutorials on platforms like YouTube. Many creators provide step-by-step instructions, which can be helpful for beginners. Ensure you find a tutorial that suits your preferred language and pace of learning.
COMMUNICATE WITH HASAN ACADEMY
[email protected]
Facebook page
/ hasanacademybanglatutorial
Subscribe link : / @hasanacademy779
Facebook group link : / 282270382269650