Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, then statement with the condition a blank cell
How do I create an If, then statement with the condition a blank cell
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If condition for Blank Cell | Excel Worksheet Functions | |||
if statement when cell is blank | Excel Worksheet Functions | |||
IF statement and color formatting for cell B1 for condition in A1 | Excel Worksheet Functions | |||
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Keep cell blank if condition is false in IF function | Excel Discussion (Misc queries) |