Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|