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

[kathysonisland]

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.

 

[Luke M]

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

--
Best Regards,

Luke M

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]

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 -----

 

[Dulanic]

This is just a quick formula, if you need anything more details it is
easy change.

=IF(G2>"0",0,D2)


This was what I needed, Thank you! But now it leads me to the next

 

[David Biddulph]

Which date satisfies that formula? Don't all numbers have smaller value
than all strings, hence any date will be less than the string "0"? Wouldn't
it have been better without the quote marks?

 

[Dulanic]

It was me writing it extremely quickly in a blank cell in excel since
had it open anyways and in error added the " around. Yes it should hav
been a 0.


Which date satisfies that formula? Don't all numbers have smalle
value