|
Data |
|
|---|---|
|
15 |
|
|
9 |
|
|
8 |
|
|
Sprockets |
|
|
Widgets |
|
|
Formula |
Description (Result) |
|
=IF(A2=15, “OK”, “Not okay”) |
If the worth in cell A2 equates to 15, return “OK.” Otherwise, return “Not OK.” (OK) |
|
=IF(A2<>15, “OK”, “Not OK”) |
If the worth in cell A2 is not equivalent to 15, return “OK.” Otherwise, return “Not OK.” (Not OKAY) |
|
=IF(NOT(A2 A3, A2 A3, A2 |
