If neither statement is true, Excel returns a value of FALSE. If at least one statement is true, the result TRUE is displayed. If both statements are true, the result TRUE is displayed. The OR formula would read as follows: = OR ( B3 > 30, C3 =“North” ) The first statement would say that the value in cell B3 is greater than 30, and the second statement would say that the value in cell C3 is equal to the word “North”. In order to identify the rows which satisfy one or both criteria, two statements are required. Either of these two conditions would qualify an employee for that reward. The Sales Department wants to reward all employees on the North team for outstanding overall performance, plus anyone with more than 30 sales from any other team. ![]() ![]() Here’s a practical example of how the OR function can be used.
0 Comments
Leave a Reply. |