If not blank than Formula question

KMan1190

I have a few formulas that I only want to display information whtn the data source is not blank. Currrently, when the data source is blank, the destination formula says invalid, but I want the destination to be blank. Are there any qualifiers that say " If x column is not blank, than apply formula"?

These are the formulas in question. Let me know if you have any ideas.

In example one, I want the month the chart was received to be displayed, and the cell to remain blank if the Chrt Review column is blank.

1:

=MONTH([Chart Review Received]@row)

In example two, I want the Month to be displayed only if the Month Number column has a value in it, but to remain blank if Month Number is blank.

2:

=IF([Month Number Chart Review]@row = 1, "aJanuary", IF([Month Number Chart Review]@row = 2, "bFebruary", IF([Month Number Chart Review]@row = 3, "cMarch", IF([Month Number Chart Review]@row = 4, "dApril", IF([Month Number Chart Review]@row = 5, "eMay", IF([Month Number Chart Review]@row = 6, "fJune", IF([Month Number Chart Review]@row = 7, "gJuly", IF([Month Number Chart Review]@row = 8, "hAugust", IF([Month Number Chart Review]@row = 9, "iSeptember", IF([Month Number Chart Review]@row = 10, "jOctober", IF([Month Number Chart Review]@row = 11, "kNovember", IF([Month Number Chart Review]@row = 12, "lDecember"))))))))))))

Paul Newcome

You could use an IF statement.

=IF([Column Name]@row <> "", original_formula)

Paul Newcome

You could use an IF statement.

=IF([Column Name]@row <> "", original_formula)

Dale Murphy

Another approach could be: IFERROR(original_formula,"")

Dale

KMan1190

Thank you Paul!

Paul Newcome

Happy to help. 👍️

@DMurphy

*DISCLAIMER: I have no proof of anything. The below is just my way of thinking and personal preference.

I feel like going the route I went with the IF the cell is not blank might be a little more efficient on the back-end because it first evaluates a single cell and will stop as soon as it realizes it is blank/only runs the full formula on rows where that cell is not blank whereas going the route of the IFERROR means it is running the full formula on every single row all the time.

Again... I have never done any testing on how much more efficient (if any) it is. It is just the reasoning behind why I used the IF as opposed to the IFERROR.

KMan1190