Excel IFS Function: How to Use It, with Examples Turkish: ÇOKEĞER
Checks several conditions in order and returns the value of the first one that is true, saving you from nesting IF functions.
IFS syntax
=IFS(logical_test1, value_if_true1, …)
In Turkish Excel: =ÇOKEĞER(mantıksal_sınama1; eğer_doğruysa_değer1; …)
Argument
Description
logical_test1
The first condition.
value_if_true1
Result when the first condition is true.
…
Add as many condition/value pairs as you need.
IFS 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
=IFS(C4>=30,"High",C4>=10,"Medium",TRUE,"Low")
Result: High
30 or more is High, 10 or more is Medium, everything else is Low.
Results were calculated in real Excel.
Tips for IFS
If no condition matches, IFS returns #N/A; add TRUE as the last condition for a default value.
Related functions
More formula guides
More tools
About IFS Function
Checks several conditions in order and returns the value of the first one that is true, saving you from nesting IF functions.
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 IFS Function
Type the formulaStart typing =IFS( 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 IFS in Turkish Excel?
In Turkish Excel, IFS is called ÇOKEĞER. Turkish Excel also separates arguments with semicolons (;) instead of commas.