Problem figuring formula

MarthaMartha · Feb 16, 2006

Help. I want cell C20 to populate a formula that is

If cell h20 is $0
then put cell G20 there

I thought it was something like =sum(IF

Bernard Liengme · Feb 16, 2006

=IF(H20=0,G20,"")
or
=IF(H20=0,G20,"it ain't zero")
best wishes

George · Feb 16, 2006

You can also use something like
=(H20=0)*G20

This will put G20 when h20=0 and zero otherwise

George