Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA
I have the following formula in Cell H4
= cell C5 (which is the end date) minus cell C10 (which is the start date) I want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty. Thank you. -- KK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA
=IF(COUNT(C10,C5)=2,C5-C10,0)
OR =IF(C10,C5-C10,0) If this post helps click Yes --------------- Jacob Skaria "Kay" wrote: I have the following formula in Cell H4 = cell C5 (which is the end date) minus cell C10 (which is the start date) I want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty. Thank you. -- KK |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA
One way...
=IF(COUNT(C5,C10)<2,0,C5-C10) -- Biff Microsoft Excel MVP "Kay" wrote in message ... I have the following formula in Cell H4 = cell C5 (which is the end date) minus cell C10 (which is the start date) I want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty. Thank you. -- KK |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA
Try this in H4:
=IF(LEN(C10)=0,0,C5-C10) Hope this helps, Hutch "Kay" wrote: I have the following formula in Cell H4 = cell C5 (which is the end date) minus cell C10 (which is the start date) I want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty. Thank you. -- KK |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA
"Kay" wrote:
I have the following formula in Cell H4 = cell C5 (which is the end date) minus cell C10 (which is the start date) I want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty. Depends on your definition of "empty". I suspect you mean: __appears__ empty. The simplest formula is: =if(C10="", 0, C5 - C10) Do not use IF(ISBLANK(C10),"",...). ISBLANK returns true only when the cell is truly empty; that is, no formula and no constant. If you use the formula above in H4, H4 might be an example of a cell that __appears__ empty, but ISBLANK(H4) is FALSE. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA
I mean there is no "START
DATE" entered in the cell (it is just empty) -- KK "JoeU2004" wrote: "Kay" wrote: I have the following formula in Cell H4 = cell C5 (which is the end date) minus cell C10 (which is the start date) I want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty. Depends on your definition of "empty". I suspect you mean: __appears__ empty. The simplest formula is: =if(C10="", 0, C5 - C10) Do not use IF(ISBLANK(C10),"",...). ISBLANK returns true only when the cell is truly empty; that is, no formula and no constant. If you use the formula above in H4, H4 might be an example of a cell that __appears__ empty, but ISBLANK(H4) is FALSE. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA
The formula is in H4 - I want to use both formula C5-C10 =, but if C10 is
empty H4 is to =0 -- KK "JoeU2004" wrote: "Kay" wrote: I have the following formula in Cell H4 = cell C5 (which is the end date) minus cell C10 (which is the start date) I want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty. Depends on your definition of "empty". I suspect you mean: __appears__ empty. The simplest formula is: =if(C10="", 0, C5 - C10) Do not use IF(ISBLANK(C10),"",...). ISBLANK returns true only when the cell is truly empty; that is, no formula and no constant. If you use the formula above in H4, H4 might be an example of a cell that __appears__ empty, but ISBLANK(H4) is FALSE. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA
Hi Kay,
=if(C10="",0,C5-C10) "Kay" wrote: The formula is in H4 - I want to use both formula C5-C10 =, but if C10 is empty H4 is to =0 -- KK "JoeU2004" wrote: "Kay" wrote: I have the following formula in Cell H4 = cell C5 (which is the end date) minus cell C10 (which is the start date) I want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty. Depends on your definition of "empty". I suspect you mean: __appears__ empty. The simplest formula is: =if(C10="", 0, C5 - C10) Do not use IF(ISBLANK(C10),"",...). ISBLANK returns true only when the cell is truly empty; that is, no formula and no constant. If you use the formula above in H4, H4 might be an example of a cell that __appears__ empty, but ISBLANK(H4) is FALSE. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA
"Kay" wrote:
I mean there is no "START DATE" entered in the cell (it is just empty) Okay. But you can still use simply IF(C10="",0,...), and I still think that is preferrable to IF(ISBLANK(C10),0,...). ----- original message ----- "Kay" wrote in message ... I mean there is no "START DATE" entered in the cell (it is just empty) -- KK "JoeU2004" wrote: "Kay" wrote: I have the following formula in Cell H4 = cell C5 (which is the end date) minus cell C10 (which is the start date) I want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty. Depends on your definition of "empty". I suspect you mean: __appears__ empty. The simplest formula is: =if(C10="", 0, C5 - C10) Do not use IF(ISBLANK(C10),"",...). ISBLANK returns true only when the cell is truly empty; that is, no formula and no constant. If you use the formula above in H4, H4 might be an example of a cell that __appears__ empty, but ISBLANK(H4) is FALSE. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|