There are many ways of doing this. For example the formula below will return A15 when A1 is less than 100 and A17 when A1 is greater than or equal to 100. To evaluate two or more conditions and return one result if any of the conditions is TRUE and another result if all the conditions are FALSE embed the OR function in the logical test of IF.
The AND function returns TRUE if the first score is greater than or.
Suppose youd like to plot the following equation. The Excel IF Statement tests a given condition and returns one value for a TRUE result and another value for a FALSE result. Type the formula for the IF Function. The following image shows how to create the y-values for this equation in Excel using the range of 1 to 10 for the x-values.