Forum Discussion

JunSheng's avatar
JunSheng
Copper Contributor
Apr 29, 2019
Solved

IF Function help!

Hello, I am trying to add the IF function to a number of cells horizontally for a set of data vertically using autofill To understand this better, ill use this function as an example: =IF(ISBLANK(B2...
excel
Formulas and Functions
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Apr 29, 2019

    JunSheng 

     

    If you go with Twifoo 's suggestion I'd recommend typing in the column references (see yellow cells) rather than relying on the COLUMN() formula, because if someone inserts a column A then you'll get the wrong results

     

     

    Another option is to use the Transpose Function combined with entering it as an array (pressing Ctrl+Shift+Enter) to get the curly brackets.  But if you are new to Excel this will be confusing.

     

    I've attached an example file

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Apr 29, 2019

JunSheng 

 

If you go with Twifoo 's suggestion I'd recommend typing in the column references (see yellow cells) rather than relying on the COLUMN() formula, because if someone inserts a column A then you'll get the wrong results

 

 

Another option is to use the Transpose Function combined with entering it as an array (pressing Ctrl+Shift+Enter) to get the curly brackets.  But if you are new to Excel this will be confusing.

 

I've attached an example file