Wednesday, July 9, 2014

AND/OR Formula

OR Formula
=OR(A2,B2)
If either cells adjacent in column A OR B are not equal to 0 then the answer will be True or if any of the adjacent cells are equal to 0 it will answer false.

AND Formula
=AND(A2,B2)
If both cells adjacent in column A AND B are not equal to 0 then the answer will be True or if any of the adjacent cells are equal to 0 it will answer false.



Read More..

www.cineclouds.com. Powered by Blogger.