Which of the following is true regarding the use of the IF function in Excel?
1
It checks a condition and returns one value if true, another if false.
2
It is used only for numerical values.
3
It cannot be nested within other functions.
4
It is used to reference external data sources.