IF formula

Y

Yuselin

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.
 
M

Michael M

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(A1>75,"Passed","Failed")

HTH
Michael M
 
Top