XOR logic in Excel

XOR logic in Excel

Unlike the OR function which returns TRUE if only 1 condition is TRUE, the XOR function returns TRUE if the number of TRUE conditions is ODD and FALSE if the number of TRUE Conditions is EVEN. Like the OR Function, at least one of the test conditions must evaluate to...
OR Logic in Excel Formula

OR Logic in Excel Formula

When testing for multiple conditions, OR logic is used to determine if ANY condition in the test is TRUE. The only time OR function evaluates to FALSE is if all conditions in a test are false =OR( 2>5, 6>5 ) will evaluate to TRUE though the first logical test...
101 Ways to Save Time Using Excel Fill Series

101 Ways to Save Time Using Excel Fill Series

If you are not using the excel fill series in your day-to-day tasks you are wasting a lot of time You can quickly enter sequential numbers or numbers following a pattern using the Autofill options. And since excel stores Dates & Times as numbers, these can also be...