Hello, I am using the following formula in a cell on a worksheet and was wondering if there is a VB alternative which accomplishes the same function: =IF((AND(B2="Yes",B3="No",B4="Yes",B5="no")),"Yes","") Thanks!