Excel fill on the IF formula not the following sequence
Excel fill on the IF formula not the following sequence
8622-Aug-2023
Updated on 23-Aug-2023
Home / DeveloperSection / Forums / Excel fill on the IF formula not the following sequence
Excel fill on the IF formula not the following sequence
Aryan Kumar
23-Aug-2023If you are using the
IF
function in Excel, you can use theFILL
function to fill the formula down a column or across a row. However, if theIF
function contains a logical test that does not return a Boolean value, theFILL
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, theFILL
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 theIF
function to a Boolean value. The following formula will work:The
IFERROR
function in this example returns a Boolean value, which theFILL
function can then use to fill the formula down the column.Here are some additional tips for using the
IF
andFILL
functions together:IF
function returns a Boolean value.IFERROR
function to convert any text values returned by theIF
function to Boolean values.FILL
function to fill the formula down the column or across the row.