Forum Discussion
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...
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
