OR Formula in Microsoft excel
OR Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used What Does It Do ? This function tests two or more conditions to see if any of them are true. It can be used to test that at least one of a series of numbers meets certain conditions. Normally the OR() function would be used in conjunction with a function such as =IF(). Syntax =OR(Test1,Test2) Note that there can be up to 30 possible tests. Formatting When used by itself it will show TRUE or FALSE. Example The following table shows a list of orders taken by a company. A handling charge of £5 is made on all orders paid by Visa or Delta cards. The =OR() function has been used to determine whether the charge needs to be applied.