A1 * IF (A1 = "Discount"; 1-10%; 1) Here are some examples of a nested IF function. In these cases, multiple IF functions are applied to the data, generating one of several responses depending on the ...