| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding a cell with a formula.
I have the following formula: =WORKDAY(A56,5,Due!$H$1376:$H$1390)
If column A has a value, then the column with the formula returns a date. However, if column A does not yet have a value (but will in the future) then the column with the formula returns with 01/06/00. How can I get the column with the formula to remain blank if there is not yet a value in column A? Thanks!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hiding a cell with a formula.
Use the IF()..
=IF(A56="","",WORKDAY(A56,5,Due!$H$1376:$H$1390)) If this post helps click Yes --------------- Jacob Skaria "BMoran" wrote: I have the following formula: =WORKDAY(A56,5,Due!$H$1376:$H$1390) If column A has a value, then the column with the formula returns a date. However, if column A does not yet have a value (but will in the future) then the column with the formula returns with 01/06/00. How can I get the column with the formula to remain blank if there is not yet a value in column A? Thanks!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hiding a cell with a formula.
One way...
=IF(COUNT(A56),WORKDAY(A56,5,Due!$H$1376:$H$1390), "") -- Biff Microsoft Excel MVP "BMoran" wrote in message ... I have the following formula: =WORKDAY(A56,5,Due!$H$1376:$H$1390) If column A has a value, then the column with the formula returns a date. However, if column A does not yet have a value (but will in the future) then the column with the formula returns with 01/06/00. How can I get the column with the formula to remain blank if there is not yet a value in column A? Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding formula in cell | Excel Discussion (Misc queries) | |||
| Hiding the error caused by the formula in a cell / column | Excel Discussion (Misc queries) | |||
| Hiding the results of a formula generated from a blank cell | Excel Discussion (Misc queries) | |||
| hiding the cell and the formula bar | Excel Discussion (Misc queries) | |||
| Hiding the value of a formula if 1 cell has a value of zero. | Excel Discussion (Misc queries) | |||
Linear Mode
