Say I want the value of B2 to be the value of A1. But if there is nothing in A1, I want the value of B2 to be B1. but if there is nothign in B1, I want the value of B2 to be C1. Im trying to fill out B2 based on a priority system. How would I go about doing this?