This is a merged cell. Should the count be 1 or 5?

"Jacob Skaria" wrote:

For multiple cells try
=IF(COUNTBLANK($A$8:$E$8)=5,"Needed","Reported")

If this post helps click Yes
---------------
Jacob Skaria


"vew" wrote:

I am dense today. I could not seem to get your formula correct. How do I
say if this cell is blank, show needed, else show reported?

=IF(FACDS/BSC/RPT/Customer/Measure Reporting/[Calls Answered.xls]09-3 Entry
Form'!$A$8:$E$8 = ??, "Needed", "Reported")


"Sam Wilson" wrote:

=IF(ISBLANK("A1"),"True Condition","False Condition")

Sam

"vew" wrote:

How do I create an If, then statement with the condition a blank cell