Excel IF Function: How to Use It, with Examples Turkish: EĞER
Tests a condition and returns one value when it is true and another when it is false. Used for any decision such as showing "Pass/Fail" based on a score.
In Turkish Excel: =EĞER(mantıksal_sınama; [eğer_doğruysa_değer]; [eğer_yanlışsa_değer])
Argument
Description
logical_test
A comparison that is TRUE or FALSE (e.g. C2>10).
[value_if_true]
Returned when the test is TRUE.
[value_if_false]
Returned when the test is FALSE.
IF examples
Sample table:
A
B
C
D
1
Product
Region
Quantity
Price
2
Pen
Ankara
12
5
3
Notebook
İzmir
8
20
4
Eraser
Ankara
30
2
5
Notebook
Ankara
5
20
6
Pen
İzmir
7
5
=IF(C2>10,"High","Low")
Result: High
Shows "High" if the quantity is greater than 10, otherwise "Low".
=IF(B3="Ankara",C3*D3,0)
Result: 0
Returns the amount if the region is Ankara, otherwise 0.
Results were calculated in real Excel.
Tips for IF
Put text in double quotes.
For many conditions, IFS is easier to read than nested IFs.
Turkish Excel separates arguments with semicolons (;) instead of commas.
Related functions
More formula guides
More tools
About IF Function
Tests a condition and returns one value when it is true and another when it is false. Used for any decision such as showing "Pass/Fail" based on a score.
Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.
How to use IF Function
Type the formulaStart typing =IF( in a cell; Excel shows the arguments.
Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
Press EnterCheck the result; you can also try it in the tester below.
Frequently asked questions
What is IF in Turkish Excel?
In Turkish Excel, IF is called EĞER. Turkish Excel also separates arguments with semicolons (;) instead of commas.
Which Excel versions have IF?
IF is available in all current Excel versions (2010 and later, Microsoft 365).