If, then statement with the condition a blank cell
 

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

If, then statement with the condition a blank cell
 

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

Sam

"vew" wrote:

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

If, then statement with the condition a blank cell
 

You mean

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

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


"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

If, then statement with the condition a blank cell
 

Yep, just testing! It's been a long day.


"Jacob Skaria" wrote:

You mean

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

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


"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

If, then statement with the condition a blank cell
 

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

If, then statement with the condition a blank cell
 

That's not a cell, it's a range of cells... What do you want it do? If all of
them are blank show "Needed", or do you want to restircit to say if A8 is
blank?

For the latter, it's:

=IF(ISBLANK(FACDS/BSC/RPT/Customer/Measure Reporting/[Calls
Answered.xls]'09-3 Entry Form'!$A$8),"True Condition","False Condition")


"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

If, then statement with the condition a blank cell
 

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

If, then statement with the condition a blank cell
 

It is a merged cell so I am not sure if I need to say if all cells are blank
or if just the first cell is blank.


"Sam Wilson" wrote:

That's not a cell, it's a range of cells... What do you want it do? If all of
them are blank show "Needed", or do you want to restircit to say if A8 is
blank?

For the latter, it's:

=IF(ISBLANK(FACDS/BSC/RPT/Customer/Measure Reporting/[Calls
Answered.xls]'09-3 Entry Form'!$A$8),"True Condition","False Condition")


"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

If, then statement with the condition a blank cell
 

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

If, then statement with the condition a blank cell
 

Should be 1. Select the cells and check the cell address shown in the namebox..

"vew" wrote:

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

If, then statement with the condition a blank cell
 

=IF((ISBLANK(...Form'!$A$8), "Needed", "Reported")
or
=IF(...Form'!$A$8="", "Needed", "Reported")

Fill in the path and file and sheet name appropriately, the easiest way
being to click in the relevant cell on the relevant sheet after you've
started your formula with =

The difference between the 2 formulae above is that ISBLANK will not return
true for an empty string ="", but the second formula will regard that
condition as true.
--
David Biddulph

"vew" wrote in message
...
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