Conditional+Formatting+Reference

= =

=Conditional Formulas =

These are couple of formulas you guys can refer to for the Upcoming excel HWs. This Class is Excel Heavy and these should come in handy.

3.value_if_false: The value to return if the condition is false.
.........................

24) || Is 15 plus 9 not equal to 24? (FALSE) || "Widgets") || Is A5 not equal to "Sprockets" or A6 equal to "Widgets"? (TRUE) ||
 * ~ Formula ||~ Description (Result) ||
 * =AND(A2>A3, A2A3, A2"Sprockets",A6=====

15, "OK", "Not OK") || If the value in cell A2 equals 15, then return "OK". (OK) || 15), "OK", "Not OK") || If the value in cell A2 is not less than or equal to 15, then return "OK". (Not OK) ||
 * ~ Formula ||~ Description (Result) ||
 * =====IF(A2=====
 * =IF(A2<>15, "OK", "Not OK") || If the value in cell A2 is not equal to 15, then return "OK". (Not OK) ||
 * =====IF(NOT(A2<=====
 * =IF(A5<>"SPROCKETS", "OK", "Not OK") || If the value in cell A5 is not equal to "SPROCKETS", then return "OK". (Not OK) ||
 * =IF(AND(A2>A3, A2A3, A2<>A4), "OK", "Not OK") || If 15 is not equal to 9 and 15 is not equal to 8, then return "OK". (OK) ||
 * =IF(OR(A2>A3, A2"Sprockets", A6<>"Widgets"), "OK", "Not OK") || If the value in cell A5 is not equal to "Sprockets" or "Widgets", then return "OK". (Not OK) ||
 * =IF(OR(A2<>A3, A2<>A4), "OK", "Not OK") || If 15 is not equal to 9 or 15 is not equal to 8, then return "OK". (OK) ||

By Tallal Tallat