Excel Formulas to Check the Conditional Message with REPT Function!!
Tags: excelformula, excelformulas
Published: 2021-06-16 10:42:22

---
title: Excel Formulas to Check the Conditional Message with REPT Function!!
published: true
date: 2021-06-04 06:17:31 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-check-the-conditional-message-with-rept-function/
---

Normally we can use the **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** to check the condition and do some actions based on the result. But without this function how can you check the conditions. Are there any effective ways for solving this problem? In this article, we will show the simple tricks that help to check the criteria and **display the conditional message in Excel by using the REPT function**. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Conditional message with REPT function](https://geekexcel.com/wp-content/uploads/2021/06/Conditional-message-with-REPT-function.png)](https://geekexcel.com/excel-formulas-to-check-the-conditional-message-with-rept-function/conditional-message-with-rept-function/#main)<figcaption id="caption-attachment-46052">A conditional message with REPT function</figcaption>

## General Formula:

- If you want to display a conditional message in Excel, you can use the below formula based on REPT function.

**=[REPT](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)(“message”,logical test)**

## Syntax Explanations:

- **REPT** – In Excel, the [**REPT function**](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/) helps to repeat characters a given number of times.
- **Logical Test** – It specifies the condition that you need to check.
- **Message** – It represents the conditional message to be displayed.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- Here, we will enter the input values in **Column B** and **Column C**.
- Now we need to check the certain condition and display the message.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-8.png)<figcaption id="caption-attachment-46050">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-12.png)<figcaption id="caption-attachment-46053">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-11.png)<figcaption id="caption-attachment-46051">Result</figcaption>

## Closure:

So yeah guys this is the simple and easy method to **display a conditional message in Excel by using the REPT function**. I hope that this article is useful to you. If you have any **doubts** regarding this topic or any other Excel VBA-related topic, ask in the **comments** section below.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**
- **[How to Validate Only Numbers in Cell in Excel Office 365?](https://geekexcel.com/how-to-validate-only-numbers-in-cell-in-excel-office-365/)**
- **[{Tricks} Excel Formulas to Combine Text And Date Into Same Cell!!](https://geekexcel.com/excel-formulas-to-combine-text-and-date/)**
- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**