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 ...

As the name suggests, a nested IF function is where there is an IF function inside an IF function. Let me explain how these work with an example. We’ll enter a nested IF expression that finds ...