Thursday 17 September 2015

Excel Tips - Tip 30 (Using OR Formulae)

Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.

If ever we want to test one or more command to get the outcome, we use the OR Command for the same.


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


How to use it ?

'IF(OR(Test1,Test2),TRUE,FALSE)


For example, please check the images.




Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.


If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:


If you have something that you want to share with the group, please write to excelms.tips@gmail.com


Thanks & Regards,

CA Mohit Bansal
Excel Enthusiast

+91-9045773456




No comments:

Post a Comment