Logical functions in Canva Sheets
Logical functions help evaluate conditions and return results based on specific criteria. These are useful for decision-making within spreadsheets.
FUNCTION | WHAT IT DOES | EXAMPLE |
IF | Returns one value if a condition is met, another if not. | =IF(A1>10, "High", "Low") |
IFS | Evaluates multiple conditions and returns the first true result. | =IFS(A1>90, "A", A1>80, "B", A1>70, "C") |
COUNTIF | Counts cells that meet a specific condition. | =COUNTIF(A1:A10, ">50") |
COUNTIFS | Counts cells based on multiple conditions. | =COUNTIFS(A1:A10, ">50", B1:B10, "<100") |
AVERAGEIF | Calculates the average of values that meet a specific condition. | =AVERAGEIF(A1:A10, ">50") |
AVERAGEIFS | Calculates the average based on multiple conditions. | =AVERAGEIFS(A1:A10, B1:B10, ">50", C1:C10, "<100") |
SUMIF | Adds numbers that meet a specific condition. | =SUMIF(A1:A10, ">50") |
SUMIFS | Adds numbers based on multiple conditions. | =SUMIFS(A1:A10, B1:B10, ">50", C1:C10, "<100") |
AND | Returns TRUE if all conditions are met. | =AND(A1>10, B1<100) |
OR | Returns TRUE if at least one condition is met. | =OR(A1>10, B1<100) |
NOT | Returns the opposite of a logical statement. | =NOT(A1>10) |
IFERROR | Returns a default value if an error occurs. | =IFERROR(A1/B1, "Error") |
ISBLANK | Checks if a cell is empty. | =ISBLANK(A1) |
ISERROR | Checks if a value is an error (TRUE for errors, FALSE if not). | =ISERROR(A1/B1) |
IFNA | Returns a value if it's not a #N/A error, otherwise returns an alternate value. | =IFNA(value, value_if_na) |
XOR | Returns TRUE if an odd number of arguments are TRUE. | =XOR(logical1, [logical2], ...) |
Was this helpful?
Helpful
Unhelpful