V
vew
How do I create an If, then statement with the condition a blank cell
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sam Wilson
=IF(ISBLANK("A1"),"True Condition","False Condition")
Sam
Sam
J
Jacob Skaria
You mean
=IF(ISBLANK(A1),"True Condition","False Condition")
If this post helps click Yes
=IF(ISBLANK(A1),"True Condition","False Condition")
If this post helps click Yes
S
Sam Wilson
Yep, just testing! It's been a long day.
Jacob Skaria said:You mean
=IF(ISBLANK(A1),"True Condition","False Condition")
If this post helps click Yes
V
vew
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")
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")
S
Sam Wilson
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")
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 said: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 said:=IF(ISBLANK("A1"),"True Condition","False Condition")
Sam
"vew" wrote:
J
Jacob Skaria
For multiple cells try
=IF(COUNTBLANK($A$8:$E$8)=5,"Needed","Reported")
If this post helps click Yes
---------------
Jacob Skaria
=IF(COUNTBLANK($A$8:$E$8)=5,"Needed","Reported")
If this post helps click Yes
---------------
Jacob Skaria
vew said: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 said:=IF(ISBLANK("A1"),"True Condition","False Condition")
Sam
"vew" wrote:
V
vew
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.
or if just the first cell is blank.
Sam Wilson said: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 said: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 said:=IF(ISBLANK("A1"),"True Condition","False Condition")
Sam
"vew" wrote:How do I create an If, then statement with the condition a blank cell
V
vew
This is a merged cell. Should the count be 1 or 5?
Jacob Skaria said:For multiple cells try
=IF(COUNTBLANK($A$8:$E$8)=5,"Needed","Reported")
If this post helps click Yes
---------------
Jacob Skaria
vew said: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 said:=IF(ISBLANK("A1"),"True Condition","False Condition")
Sam
"vew" wrote:How do I create an If, then statement with the condition a blank cell
J
Jacob Skaria
Should be 1. Select the cells and check the cell address shown in the namebox..
vew said:This is a merged cell. Should the count be 1 or 5?
Jacob Skaria said:For multiple cells try
=IF(COUNTBLANK($A$8:$E$8)=5,"Needed","Reported")
If this post helps click Yes
---------------
Jacob Skaria
vew said: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")
:
=IF(ISBLANK("A1"),"True Condition","False Condition")
Sam
:
How do I create an If, then statement with the condition a blank cell
D
David Biddulph
=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
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 said: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 said:=IF(ISBLANK("A1"),"True Condition","False Condition")
Sam
"vew" wrote:
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.