---
title: "Excel fill on the IF formula not the following sequence"  
description: "Excel fill on the IF formula not the following sequence"  
author: "Steilla Mitchel"  
published: 2023-08-22  
updated: 2023-08-23  
canonical: https://www.mindstick.com/forum/159632/excel-fill-on-the-if-formula-not-the-following-sequence  
category: "excel"  
tags: ["excel", "excel formula"]  
reading_time: 2 minutes  

---

# Excel fill on the IF formula not the following sequence

[Excel](https://www.mindstick.com/articles/12937/how-to-import-excel-data-in-sql-server-2014) fill on the IF [formula](https://answers.mindstick.com/qa/35906/is-formula-1-s-popularity-in-decline) not the following [sequence](https://www.mindstick.com/interview/34504/difference-between-identity-vs-sequence)

## Replies

### Reply by Aryan Kumar

If you are using the `IF` function in Excel, you can use the `FILL` function to fill the formula down a column or across a row. However, if the `IF` function contains a logical test that does not return a Boolean value, the `FILL` function will not work.

For example, the following formula will not work:

```plaintext
=IF(A1>10, "Greater than 10", "Less than or equal to 10")
```

The `IF` function in this example returns a text value, not a Boolean value. Therefore, the `FILL` function will not fill the formula down the column.

To fix this, you can use the `IFERROR` function to convert the text value returned by the `IF` function to a Boolean value. The following formula will work:

```plaintext
=IFERROR(IF(A1>10, "Greater than 10", "Less than or equal to 10"), "")
```

The `IFERROR` function in this example returns a Boolean value, which the `FILL` function can then use to fill the formula down the column.

Here are some additional tips for using the `IF` and `FILL` functions together:

- Make sure that the logical test in the `IF` function returns a Boolean value.
- Use the `IFERROR` function to convert any text values returned by the `IF` function to Boolean values.
- Use the `FILL` function to fill the formula down the column or across the row.


---

Original Source: https://www.mindstick.com/forum/159632/excel-fill-on-the-if-formula-not-the-following-sequence

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.