Home Computer Learn OR Function in excel to compare 2 Conditions.

Learn OR Function in excel to compare 2 Conditions.

1 min read
0
0
68
1ST.3 1

OR

Learn Or Function how to use with IF Formula

 

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.

ExampleThe 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.
Learn OR function in excel use with if formula
Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

How to Check BUSY Updates

How to Check BUSY Updates Company > Check BUSY Updates Check BUSY Updates option provid…