Excel fill on the IF formula not the following sequence

Question

Aryan Kumar · Answer

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: 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: 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.

forum

Excel fill on the IF formula not the following sequence

Can you answer this question?

1 Answers