If functions

Question 1

if

Answer 1

allows you to make logical comparisons between a value and what you expect.

For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).

Question 2

10

iferror

Answer 2

IFERROR(value, value_if_error)

The IFERROR function syntax has the following arguments:

value Required. The argument that is checked for an error.

value_if_error Required. The value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.

Question 3

4

sumifs formula

Answer 3

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

if you want to sum cells that have the same root but different variations (amazon eu, amazon US, amazon, etc.), use the a cell reference with “amazon” in it and then add “*” to indicate that no matter what comes after, it gets added in

Question 4

ifs

Answer 4

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.

=IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)

Question 5

nested ifs

Answer 5

AND – =IF(AND(Something is True, Something else is True), Value if True, Value if False)

OR – =IF(OR(Something is True, Something else is True), Value if True, Value if False)

NOT – =IF(NOT(Something is True), Value if True, Value if False)