I am trying to create a priority rank depending on a drop down selection - then if cell C9 is blank then this is prioirty one, if cell C10 is blank this is prioirty two, ALTHOUGH is cell C11 and C12 are not blank I want to skip these as priorities, and if cell 13 is blank this will be prioirty three

PLEASE HELP

Thanks,
Emily