I have a calculated column (see below) testing the content of six rating columns and it is working, however, I want to add a condition so that only those columns that are not null are tested. A list item may or may not have all six ratings but if all the ratings on a given item are low, then x = Low. I believe I can use ISBLANK but I can't get the formula to work. Can anyone help? Thanks in advance!
=IF(AND([Rate1]="Low",[Rate2]="Low",[Rate3]="Low",[Rate4]="Low",[Rate5]="Low",[Rate6]="Low"),"Low","Med")