So if you wanted B3B9 youd need to list each cell individually in your function. We learned about IF with AND Function in Excel and IF with OR Function in Excel previously. We can use the function to test multiple conditions at the same time up to 255 conditions in total.
IF OR statement in Excel To evaluate two or more conditions and return one result if any of the conditions is TRUE and another result if all the conditions are FALSE embed the OR function in the logical test of IF.
The most used functions in Excel are the functions that count and sum. The rows and columns in the range of cells returned by the OFFSET function always use the cell lying 1 column up and 1 column to the left of the returned range for reference. If the condition will not match then it will return as a FALSE. It will result in TRUE if any of the condition or argument evaluates match the given condition.