Conditional Functions¶
This contains the list of conditional functions that are currently supported by Codcel.
A¶
AVERAGEIF¶
Calculates the average (arithmetic mean) of all cells that meet a specified condition.
- Example:
=AVERAGEIF(A1:A10, ">5")
C¶
COUNTIF¶
Counts the number of cells within a range that meet a single specified criterion.
- Example:
=COUNTIF(A1:A10, ">5")
I¶
IF¶
Checks whether a condition is met and returns one value if TRUE and another if FALSE.
- Example:
=IF(A1 > 10, "High", "Low")
IFERROR¶
Catches errors in a formula and replaces them with a specified alternative value.
- Example:
=IFERROR(A1/B1, "Error")
IFS¶
Checks multiple conditions and returns a value corresponding to the first true condition.
- Example:
=IFS(A1>=90, "A", A1>=80, "B", A1>=70, "C")
S¶
SUMIF¶
Sums the values in a range that meet a specified criterion.
- Example:
=SUMIF(A1:A10, ">5", B1:B10)