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

  • Thread starter Thread starter kathysonisland
  • Start date Start date
K

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.
 
=IF(ISNUMBER(G2),0,D2)

--
Best Regards,

Luke M
kathysonisland said:
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.
Click to expand...
 
kathysonisland said:
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?
Click to expand...

=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 -----
 
Back
Top