How to use the IF function in Excel
How to use the IF function in Excel
See how easy it is to work with this function
We have this spreadsheet to control student grades and we want to know which students are excellent, good, and average, knowing that grades above 8 will be excellent, above 5 good, and less than 5 average.
So let's go.
Equals: if open parentheses, click on the grade greater than or equal to 8, semicolon in double quotes, excellent
Here we are defining that if the grade is greater than or equal to 8 it will be excellent. Now let's add the second option, semicolon: if open parentheses, grade greater than or equal to 5, semicolon in double quotes, good. Here we are defining that if the grade is greater than or equal to 5 and less than 8 it will be good. Now let's add the third option: if it is neither of the previous options, it will be average. So let's add to the function: semicolon in double quotes, average, close the two open parentheses and press enter.
==============================================
Visit our Excel tips website where you will find many Excel tips and tricks in an easy way to learn. We also have many free spreadsheets available for download on our Excel tips website. We have spreadsheet templates for inventory control in Excel, overtime control, calendars, various lists, electronic agendas, labels and many more ready-made spreadsheets.
https://dicasdoexcel.com.br
=================================================
Check out our Excel tips channel.
Here on this channel you will learn many Excel tips and free spreadsheets to download. Subscribe to the channel so you don't miss any content.
https://youtube.com.br/dicasdoexcel
=================================================
#iffunctionsinexcel #iffunctionexcel #howtouseiffunctionsinexcel #iffunction #exceliffunction