Excel Logic functions

Question 0

If

Answer 0

=if(logic, true, false)

Tests validity

Tests 2 possible outcomes but nesting includes more outcomes (purpose: given a range of different rates)

Is A something to B? If so, then true, so calculate. If not then is A something to another b? Etc

Include the new if functions as false statements to continue the procedure

IF functions are used in decision making

Question 1

And

Answer 1

=and(logic,logic2)

All logic must be true otherwise false

Question 2

IFERROR

Answer 2

if error pops up, then directions are displayed

Question 3

Ifna

Answer 3

Same as if error

Question 4

=NOT

Answer 4

Versus the logic of an argument

Makes sure a value is not equal to a particular value

Question 5

=OR

Answer 5

True if any value is true
False if all values are false
Reverse And basically

Question 6

A logical test can only be…

Answer 6

True or False or 0 or 1

Question 7

Nests regarding if replace…

Answer 7

1 or 2 functions with an if statement