Return 0 if cell has data, of copy if it doesn't
 

This was what I needed, Thank you! But now it leads me to the next
step.....(probably would be easier to just enter the $0 myself)

Here is what I need: the 'simple' spreadsheet is for refunds we owe
clients. Column D is refund owing, Column G is date mailed, H represents $0
balance, which is the formula I was just given. Now, how do I fix the
formula to actually display the amount of refund due from Column D IF column
G isn't populated, but if it does have a date mailed then H would display $0?

I should have asked this in the first place. Sorry.

"Joe User" wrote:

"kathysonisland" wrote:
I need a formula to display 0 in a cell if another cell has a date.

Is the following sufficient?

=if(isnumber(A1), 0, "")

That returns zero if A1 ("the other cell") has a number, which includes a
date. Otherwise, it returns the null string, leaving the cell appear blank.

If you truly need to distinguish between a date and other numbers, I think
you need to write a UDF (VBA function). Is that necessary?

Also, I ass-u-me that "the other cell" contains a numeric date, not text
that looks like a date. In other words, TYPE(A1) is 1, not 2.

Return 0 if cell has data, of copy if it doesn't
 

=IF(ISNUMBER(G2),0,D2)

--
Best Regards,

Luke M
"kathysonisland" wrote in message
...
This was what I needed, Thank you! But now it leads me to the next
step.....(probably would be easier to just enter the $0 myself)

Here is what I need: the 'simple' spreadsheet is for refunds we owe
clients. Column D is refund owing, Column G is date mailed, H represents
$0
balance, which is the formula I was just given. Now, how do I fix the
formula to actually display the amount of refund due from Column D IF
column
G isn't populated, but if it does have a date mailed then H would display
$0?

I should have asked this in the first place. Sorry.

"Joe User" wrote:

"kathysonisland" wrote:
I need a formula to display 0 in a cell if another cell has a date.

Is the following sufficient?

=if(isnumber(A1), 0, "")

That returns zero if A1 ("the other cell") has a number, which includes a
date. Otherwise, it returns the null string, leaving the cell appear
blank.

If you truly need to distinguish between a date and other numbers, I
think
you need to write a UDF (VBA function). Is that necessary?

Also, I ass-u-me that "the other cell" contains a numeric date, not text
that looks like a date. In other words, TYPE(A1) is 1, not 2.

Return 0 if cell has data, of copy if it doesn't
 

"kathysonisland" wrote:
Column D is refund owing, Column G is date mailed
[....] how do I fix the formula to actually display the
amount of refund due from Column D IF column G
isn't populated, but if it does have a date mailed then
H would display $0?

=if(isnumber(G1), 0, D1)

By the way, it might be sufficient to write if G1 only contains a date or
nothing:

=if(G1<"", 0, D1)

PS: In the future, please do not duplicate questions, and do not separate
follow-ups from the original discussion. It only serves to create confusion.


----- original message -----

"kathysonisland" wrote:
This was what I needed, Thank you! But now it leads me to the next
step.....(probably would be easier to just enter the $0 myself)

Here is what I need: the 'simple' spreadsheet is for refunds we owe
clients. Column D is refund owing, Column G is date mailed, H represents $0
balance, which is the formula I was just given. Now, how do I fix the
formula to actually display the amount of refund due from Column D IF column
G isn't populated, but if it does have a date mailed then H would display $0?

I should have asked this in the first place. Sorry.

"Joe User" wrote:

"kathysonisland" wrote:
I need a formula to display 0 in a cell if another cell has a date.

Is the following sufficient?

=if(isnumber(A1), 0, "")

That returns zero if A1 ("the other cell") has a number, which includes a
date. Otherwise, it returns the null string, leaving the cell appear blank.

If you truly need to distinguish between a date and other numbers, I think
you need to write a UDF (VBA function). Is that necessary?

Also, I ass-u-me that "the other cell" contains a numeric date, not text
that looks like a date. In other words, TYPE(A1) is 1, not 2.