ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IF formula (https://www.excelbanter.com/excel-worksheet-functions/144046-if-formula.html)

Yuselin

IF formula
 
I do not know how to inser the IF formula i have tried several times and i
dont get it. I need to do a school project in which i have to put the min,
max grade and i have to make the IF formula to say if i im passing or not. I
dont even get how to start the project.

Michael M

IF formula
 
Hi Yuselin

Firstly, look in the Help files for IF, it gives a handy description and
also working examples.
Secondly, the simplest way to llok at it is:

=IF("the cell you want to look at and it's criteria", What to do if it is
true", what to do if it false)

So, if your data is in A1 and you want it to say "Passed" if your score is
over 75, and "Fail" if you score is under 75.
you would type:

=IF(A175,"Passed","Failed")

HTH
Michael M

"Yuselin" wrote:

I do not know how to inser the IF formula i have tried several times and i
dont get it. I need to do a school project in which i have to put the min,
max grade and i have to make the IF formula to say if i im passing or not. I
dont even get how to start the project.



All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com