"IF" statement? - Examples

whenever you want to present some text according to a criteria:

If the criteria is met then present "whatever want to present", in "True Place"
other wise if the criteria does not match than it show second word "whatever you want" in "False Place".

Here you see the Examples:

_______________
Using if with Text:
if a house value is higher than 10lac then you write "It is too expensive", else write "It is Affordable"

=if(logical_test,True word, False word) or =if(logical_test,It is too Expensive,It is Affordable)


______________________
Using if with Calculations:
If the deposit in the bank is greater than 1lac, then it deserves an interest of 4%, else it get only an interest of 3%.

=if(logical_test,True Value, False Value) or =if(logical_test,4%,3%).


You all can read about more IF statement from the link bellow.
IF Statement
OR function with IF
AND function with IF

Examples of formulas.....................

Hi..............friends...................

Today I am going to share few links with u.
All those links included examples of formulas.........
Every link is important according to my view.....
The more you learn the more you get..........
So the links are bellow..........

http://office.microsoft.com/en-us/excel/HP052001271033.aspx

http://www.cpearson.com/excel/excelF.htm

http://www.educationonlineforcomputers.com/blogs/post/microsoft_office_training_tutorial/574/187-Excel-Formula-Tutorials-and-Examples


http://www.xlfdic.com/

http://www.free-training-tutorial.com/formulas.html

http://office.tizag.com/excelTutorial/excelformulas.php

so thats it..................a lot of links are available...............but you have to learn and search for it.........

Remember one important thing friends...........
A forumla is nothing more than an equation that you write up. In Excel a typical formula might contain cells, constants, and even functions. Here is an example Excel formula that we have labeled for your understanding.