Otherwise, it would set the LBandwidth variable to the string value 'High'.
This would set the LBandwidth variable to the string value 'Low' if LWebsite was either '' or '' and LPages <= 10. You can use the OR function with the AND function in VBA, for example: If (LWebsite = '' Or LWebsite = '') And LPages <= 10 Then Important: The file location can be very important in Mac Excel 2016, read : Problems with Apple’s sandbox requirements in Mac Office 2016 and higher with VBA code I am currently using the following VBA code in Excel for MAC 2016: Sub MailWorkSheet Dim SourceWb As Workbook, DestWb As Workbook, sh As Worksheet Dim strbody As String. Otherwise, it would set the LResult variable to the string value 'Fair'. This would set the LResult variable to the string value 'Great' if either LWebsite was '' or LCount > 25. Join Dennis Taylor for an in-depth discussion in this video, Watching VBA code being created, part of Excel for Mac 2016: Macros. This first example combines the OR function with the IF Statement in VBA: If LWebsite = '' Or LCount > 25 Then So will be any pivot table, that was created via the 'Import from Microsoft Access Database' option as Excel for MAC does not support OLEDB connections, either. Let's look at some Excel OR function examples and explore how to use the OR function in Excel VBA code. The OR function with this syntax can only be used in VBA code in Microsoft Excel.