#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 118
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"