# How to Create a Formula in Excel That Will Place the Word Yes (7 Ways)

In this article, you will get to know about various ways to create a formula in Excel that will place the word Yes easily. Sometimes we want a result as Yes depending on the criteria met or not. So, let’s start our main article to know more about the details.

## 7 Ways to Create a Formula in Excel That Will Place the Word Yes

Here, we have the following dataset containing the sales records of a company, and using this dataset we will try to create some formulas to place the word Yes. We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience.

### Method-1: Using IF Function to Create a Formula to Place the Word Yes

Here, we will use the IF function to get Yes in the Formula column when the sales values are greater than 3000 for the products. Steps:
➤ Type the following formula in cell D4

`=IF(C4>3000,"YES","")`

Here, C4 is the Sales value, C4>3000 is the logical condition and when the condition will be TRUE it will return YES otherwise a Blank. ➤ Press ENTER and drag down the Fill Handle tool. As a result, we are getting YES for the sales values greater than \$3,000.00. ### Method-2: Using Nested IF Functions to Create a Formula in Excel That Will Place the Word Yes

In this section, we are going to use Nested IF functions or one IF function within another one to get Yes for fulfilling multiple conditions like for the Region as North and for Sales values greater than 3000. Steps:
➤ Type the following formula in cell E4

`=IF(C4="North",IF(D4>3000,"YES",""),"")`

Here, C4 is the Region, D4 is the Sales value, C4=”North ” is the first logical condition and when the condition will be TRUE it will go to another IF function, and D4>3000 is the second logical condition for this function. For not meeting the conditions we will get a Blank. ➤ Press ENTER and drag down the Fill Handle tool. Afterward, you will get YES for the products which are in the North region and have a Sales value greater than \$3,000.00. ### Method-3: Using IF, AND Functions to Create a Formula in Excel to Place the Word Yes

For having Yes when the multiple conditions like the Region as North and Sales value greater than 3000 will be met, we are using the AND function and the IF function here. Steps:
➤ Type the following formula in cell E4

`=IF(AND(C4="North",D4>3000),"Yes","")`

Here, C4 is the Region, D4 is the Sales value, C4=”North ” and D4>3000 are the logical conditions, and AND will return TRUE for meeting both conditions otherwise FALSE. For TRUE we will get Yes and for FALSE we will get a Blank. ➤ Press ENTER and drag down the Fill Handle tool. Finally, you will get Yes for the products which are in the North region and have a Sales value greater than \$3,000.00. ### Method-4: IF with OR Function to Create a Formula in Excel That Will Place the Word Yes

For meeting any one of the criteria between the Region as North and the Sales value greater than 3000, we will be using the OR function. Steps:
➤ Type the following formula in cell E4

`=IF(OR(C4="North",D4>3000),"Yes","")`

Here, C4 is the Region, D4 is the Sales value, C4=”North ” and D4>3000 are the logical conditions, and OR will return TRUE for meeting any one of these conditions otherwise FALSE. For TRUE we will get Yes and for FALSE we will get a Blank. ➤ Press ENTER and drag down the Fill Handle tool. Consequently, you will get Yes for the products when any one of the conditions is met here. ### Method-5: Considering Dates to Create a Formula in Excel That Will Place the Word Yes

To have Yes when delivery dates are matched with today’s date (3/7/2022 as m/d/yyyy format) we will use the TODAY function with the IF function. Steps:
➤ Type the following formula in cell D4

`=IF(C4=TODAY(),"YES","")`

Here, C4 is the Delivery Date, C4=TODAY() is the logical condition, and when the condition will be TRUE it will return YES otherwise a Blank. ➤ Press ENTER and drag down the Fill Handle tool. In this way, we will get YES for the delivery dates which are equal to today’s date. ### Method-6: Combine Several Excel Functions to Create a Formula to Place the Word Yes

Here, we have a list of three products and we will check if the products of this list are available in the dataset, for their availability we will get Yes in the Available or Not column by using the VLOOKUP function, ISNA function, IF function. Steps:
➤ Type the following formula in cell C13

`=IF(ISNA(VLOOKUP(B13,\$B\$3:\$D\$10,3,FALSE)),"","YES")`

Here, B13 is the lookup value, \$B\$3:\$D\$10 is the lookup range, 3 is the serial number of columns in the range from which we will extract the value for our corresponding lookup value and FALSE is for an exact match.

• VLOOKUP(B13,\$B\$3:\$D\$10,3, FALSE) → returns the corresponding sales values for the products if the value is in the list and otherwise #N/A
Output → 2260
• ISNA(VLOOKUP(B13,\$B\$3:\$D\$10,3,FALSE)) becomes
ISNA(2260) → returns TRUE for #N/A error and FALSE for other values.
Output → FALSE
• IF(ISNA(VLOOKUP(B13,\$B\$3:\$D\$10,3,FALSE)),””,”YES”) becomes
IF(FALSE,””,”YES”) → returns YES for FALSE otherwise a Blank for TRUE.
Output → YES ➤ Press ENTER and drag down the Fill Handle tool. Finally, we will get YES for the available products on the list. ### Method-7: Using IF, INDEX, MATCH, ISNA to Create a Formula in Excel That Will Place the Word Yes

In this section, we will check the available products in the list and get Yes for the available products by using the INDEX function, MATCH function, ISNA function, IF function. Steps:
➤ Type the following formula in cell C13

`=IF(ISNA(INDEX(\$D\$4:\$D\$10,MATCH(B13,\$B\$4:\$B\$10,0))),"","YES")`

Here, B13 is the lookup value, \$B\$4:\$B\$10 is the lookup array and 0 is for an exact match.

• MATCH(B13,\$B\$4:\$B\$10,0) → returns the row or column index number of the lookup value in the data range.
Output → 3
• INDEX(\$D\$4:\$D\$10, MATCH(B13,\$B\$4:\$B\$10,0)) → returns the information we actually want by using the return range \$D\$4:\$D\$10 and if the value is not present in the list then it will return #N/A
Output → 2260
• ISNA(INDEX(\$D\$4:\$D\$10,MATCH(B13,\$B\$4:\$B\$10,0))) becomes
ISNA(2260) → returns TRUE for #N/A error and FALSE for other values.
Output → FALSE
• IF(ISNA(INDEX(\$D\$4:\$D\$10,MATCH(B13,\$B\$4:\$B\$10,0))),””,”YES”) becomes
IF(FALSE,””,”YES”) → returns YES for FALSE otherwise a Blank for TRUE.
Output → YES ➤ Press ENTER and drag down the Fill Handle tool. Eventually, you will get YES for the available products on the list. ## Practice Section

For doing practice by yourself we have provided a Practice section like below in a sheet named Practice. Please do it by yourself. ## Conclusion

In this article, we tried to cover the ways to create a formula in Excel that will place the word Yes easily. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.

## Related Articles #### Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts 