With a logical function, and we're going to compare whether or not these individuals met their sales goal. So we have total sales and their goal. Just wanted to create a yes no field here. Yes if they sold more than their goal. So this is a logical formula. It's the IF function from the Formulas tab, select logical.

If, and my arguments are going to be whether or not the cell I two is greater than j two. Now if that's true, I can enter Yes. And if it's false, I can enter No. Notice that the quotation marks going around our values if they're true or false, based on if it's text that we want to output. copy that down. We're going to see our yeses and our notes there.